Kojak,

You would need to use a helper column of formulas to subtract 0.5 from times that are after Noon.

HTH,
Bernie
MS Excel MVP


"kojak" wrote in message
...
How can I get time to display without the AM or PM after it, using 12 hour
day? I am wanting something like 2:30 pm to display as just 2:30 and not as
14:30.
Thanks in advance.