How do I get??

P

PM

Sorry if this seems a fairly easy question to you guys.

I have a spreadsheet and I need to get the current system time into a cell.
The format of the time is hh:mm am/pm.

Any assistance would be most helpful.
 
P

Paul B

PM, in the cell you want put =NOW(), Format as hh:mm am/pm. if you don't
want the time to change key in Ctrl+shift+; to put in the time
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
B

Beccy

Highlight the cell you want to format. Go up to the toolbar and click on
Format then cells.
Click on the number tab, then under category box go to custom.
Then in the box under the word Type, type in:

hh:mm AM/PM

Then click OK.

This will format the cell you chose to this. So when you type in 9:00 it
will come up as 9:00 AM etc.

Hope this helps.
 
Top