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