custom time format - 12 hr without am/pm

[istril]

I'd like my times to display as h:mm, but on a 12 hour format, WITHOUT the AM or PM trailing it. I fooled around with the custom time formats, but I'm having trouble doing this without it getting converted to military time.

 

[Norie]

What did you try?

You should just be able to use hhmm or hh:mm.

 

[istril]

I tried both of those, and [h]:mm. they all give military time. if you dont put the am or pm, it seems excel wants to force you to use military time.

 

[Norie]

Sorry, are you using the AM/PM or is it Excel that is formatting the time as AM/PM?

What are the times you are trying to format?

 

[istril]

In custom formats, if you just enter h:mm, it will give you military time. You have to put in h:mm AM/PM in order to display 12 hour time, that i've seen. I'm wondering if there is a code, etc., that will specify 12 hour time without the need for the AM/PM.

when I enter the time into the cells, I'll type, for example, "6 pm" and it is spitting out "6:00 PM". It shouldn't matter what I type, though. If excel recognizes it as a time, it should then format it how I specify, and it does. I just don't know how to tell it to format it the way I want it.

 

[Norie]

Well when I type 6 pm I get 6:00PM and when I format it as hh:mm I get 18:00.

 

[istril]

Yes, as do I. That is exactly my problem. How do you make the VALUE of 18:00 hours APPEAR as 6:00?

 

[Norie]

Sorry you've lost me.

Is 18:00 hours an actual time or a count/sum/calculation of hours/minutes?

 

[istril]

... 18:00 hours IS 6:00 PM...

 

[Norie]

Eh, I know that.

You really need to give some examples, in your last post you said 'How do you make the VALUE of 18:00 hours APPEAR as 6:00?'.

What are you typing? What are you formatting?<!-- / message -->