formating military time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
| 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering a time into excel 10
Time formatting in Excel 2003 2
MEAN in Military Time 4
"h:mm" format, but 12-hour time, not 24-hour time? 4
Determine if night shift by start & end time 2
Time Cells 5
Why does my computer switch to military time? 1
Creating uniform time format from multiple formats 1

Back
Top