Format a cell to PM

[MrChevy3]

Is there a way format a cell to always show PM instead of using the military
time format? If I put 5:00 it defaults to AM, to get it show PM I half to
type the military time of 17:00. I just want it to show 5:00 PM as a default
?

Thanks for anyones help

 

[JE McGimpsey]

Is there a way format a cell to always show PM instead of using the military
time format? If I put 5:00 it defaults to AM, to get it show PM I half to
type the military time of 17:00. I just want it to show 5:00 PM as a default
?

XL doesn't have any way to infer that you mean 5:00 PM instead of 5:00
AM when you enter "5:00". Since I usually start my workday at 4:00 AM
and often finish after 10:00 PM, I'm used to using 24-hour time - I
can't think of a single rule that I could use to tell XL whether my time
sheet entry of 6:00 should be morning or evening.

You CAN enter

5:00 p

and the parser will interpret it as 5:00 PM.

The only other way I know is to use either a helper formula or an event
macro. Such a solution would have to be customized to your situation -
what rule should XL follow to determine AM or PM?