Time without "AM" or "PM"

[moebfd]

Hi All,
Hope you are fine and well.
I would like to display the time in 12 hour format without the "AM" or "PM" (after the time).
Is there anyway to do this.
Kind regards

 

[Scott Huish]

Use the custom format of h:mm AM/PM
but right before the AM/PM in the format, hold down you Alt-key on the numeric keypad hit 0010
Turn on word wrap for these cells

 

[Scott Huish]

This is a duplicate post.

Trying to input time calculation so it does not change to 24 hour format

Hi All, I am trying to do a calculation on time but don't want it to convert to 24 hour format. I have formatted all columns to h:mm As you can see from the picture below, when I enter the 12:55 it shows as 13:00 (the result). When I enter 1:00 it shows as 1:05 which is what I want to show. The...

www.mrexcel.com

 

[etaf]

This is a duplicate post.

No wonder i could not find it on the excelforums, I saw it on this forum yesterday

 

[Scott Huish]

Just curious my format gave you exactly what you asked for. How is this not the solution?