1:00PM in military time (as we in the U.S. call it) is 13:00. There is no
standard (or Excel time format) that displays 1PM as 1:00 since that is
ambiguous, as far as I know.

--
Jim
"LHaro" wrote in message
...
| Hello,
|
| I am trying to format military time in excel to display regular times
| (without displaying the AM/PM). For Example, I have a cell that contains
| 1:00:00 PM, it is displayed as 13:00, but i want it to display 1:00. Any
| help on this would be greatly appreciated.
|
| Many Thanks
|