I appreciate everyones help.
Eric I tried your formula, modifiying A1 to P5, but the answer that I got
for 4:30 pm was 0.1875. What I am wanting is for it to display 4:30 without
the pm.

"Eric" wrote:

I couldn't find a formatting solution. In the event nobody else can and you
don't mind displaying a dummy column referencing your real data, this will
show your data the way you want it when you format as 24-hour time.

Assuming your real data is in cell A1:

=IF(A1-INT(A1)13/24,A1-12/24,IF(A1-INT(A1)<1/24,A1+12/24,IF(A1-INT(A1)=13/24,1/24,A1)))

"kojak" wrote:

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.