Military Time

D

dparkerl

how can i key 4:30 and mean 4:30 pm. thanks
That's correct - Excel will take 4:30 as 4:30AM.

And please, as you are posting from the Excel Forum, which is
replicating
this newsgroup, quote the post you are replying to.

Thank you.
Click to expand...
 
G

Gordon

dparkerl cogitated deeply and scribbled thusly:
how can i key 4:30 and mean 4:30 pm. thanks
Click to expand...

You can't - you have to key in 16:30. You CAN format the cell however so
that it SHOWS 4:30 PM, but you still have to key in 16:30
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding rota 0
Linking Child Timelines to Multiple Parents 0
Min, Max 3
How can the font and size of (all) citation numbers be altered? 1
Have 4 email addresses Want to auto forward all in one of them 0
converts military time into standard AM/PM . 8
Keeping Leading Zeros; How Please ? 2
Calendar 2

Top