You can use text entries instead, of course then you can't make any
calculations
If you precede the entry with an apostrophe or preformat as text you can use
whatever you want. But you can't format a number as time without letting
Excel know what time of day it is. One hour in Excel is the number 1/24,
that means that 02:30 is 2.5*(1/24) whereas 02:30 PM is 14.5*(1/24) so the
values are not the same thus cannot be displayed the same


Regards,

Peo Sjoblom


"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.