Time Formating

[Guest]

I have created an excel spreadsheet to calculate hours worked. When entering
the start and end times, the formating automatically assumes an AM. So if I
type "5:00" the cell formats it as "05:00 AM". But if I want a PM hour
entered such as 5:00 PM, I have to enter the P. Is there some way to format
the "End Time" cells so that it assumes a PM, unless an AM is entered?

I would appreciate any suggestions.

Marianne Castrovince

 

[Bob Phillips]

Marianne,

Enter 17:00 and it will enter it as 5:00 PM.

 

[Chip Pearson]

Other than entering the PM designator, you can enter the time in
24-hour values. E.g., 17:00 for 5:00 PM.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com