Adding time AM/PM

[Guest]

How do a create a text formula that shows 13:10 as 1:10?

I don't want the PM in the text formula. When leave out the AM/PM it shows
as 13:10 and I don't want that.

Text(A1, "h:mm") shows 13:10
Text(A1, "h:mm AM/PM") shows 1:10 PM
I just wat 1:10.... no PM!
Thanks,
Joe

 

[Guest]

try this:

=LEFT(TEXT(G5,"hhh:mm am/pm"),5)

 

[Guest]

Thank you that worked!!!!

try this:

=LEFT(TEXT(G5,"hhh:mm am/pm"),5)