Thanks Dave, both of those do exactly what I was looking for.

"Dave Peterson" wrote:

If you're willing to use that helper cell:

=LEFT(TEXT(A1,"hh:mm AM/PM"),5)
or
=TEXT(MOD(A1,0.5),"h:mm")



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.

--

Dave Peterson