ExcelBanter - Adding time AM/PM

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding time AM/PM (https://www.excelbanter.com/excel-discussion-misc-queries/94832-adding-time-am-pm.html)

JoeyZaZa

Adding time AM/PM

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

Nikki

Adding time AM/PM

try this:

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

"JoeyZaZa" wrote:

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

JoeyZaZa

Adding time AM/PM

Thank you that worked!!!!

"Nikki" wrote:

try this:

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

"JoeyZaZa" wrote:

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

All times are GMT +1. The time now is 08:42 PM.