Format a cell to PM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MrChevy3 - 20 Nov 2006 18:51 GMT

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

Reply to this Message

JE McGimpsey - 20 Nov 2006 20:42 GMT

> 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?

Reply to this Message

Mac Forum / Applications / Excel / November 2006

Format a cell to PM