Default Time

G

GW

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.
 
B

Biff

Hi!

Without entering either AM/PM, AM is the default. The only way to get around
it without entering PM is to use a 24 clock:

22:00

Technically, I guess you could use an event macro that adds 12 hours to the
time entered but that's out of my area of "expertise".

Biff
 
K

Ken Wright

Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter the
current time in a cell?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
G

GW

Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter the
current time in a cell?
Click to expand...


Thanks, Ken. Yes, I knew that, but sometimes I forget to enter the
time and have to go back later to do it manually, hence the need to be
able to change the default.

Thanks to all.
 
K

Ken Wright

LOL - Dohhhhhh!!!! Brain freeze time - Thanks for the catch Chip :)

Regards
Ken....................
 
Top