Time formatting:data 1:30:20 entered reads in 1:30:20 pm

E

Ellen

I am trying to get data entered in format 1:30:25 etc... to read 1:30:25 PM
but it keeps reverting back to am.
 
B

Bob Phillips

enter 13:30:25

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
G

GS

Hi Ellen,

If you don't like using the 24 hour format:

In the case of time input, Excel assumes it's AM unless you specify " PM"
after the time value. Actually, "1:30:25 P" is all you really need to enter.

Regards,
GS
 
Top