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.