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

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
|

The only way I can think of is to display the time as text by placing a ' in
front of the time. Note: you will not be able to utilize these cells to
calculate times.

"Jim Rech" wrote:

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
|