D
Dave
How would you format a cell to reflect military time???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
True military time:
Format/Cells/Number/Custom hhmmssZ
Note that you can't directly enter that format, since XL requires a
colon to indicate time to the parser. You can leave off the time zone
indication for local time.
If you want the colon(s):
Format/Cells/Number/Custom hh:mm:ss
Format/Cells/Number/Custom hhmmssZ
Note that you can't directly enter that format, since XL requires a
colon to indicate time to the parser. You can leave off the time zone
indication for local time.
If you want the colon(s):
Format/Cells/Number/Custom hh:mm:ss
H
Harlan Grove
Dave said:How would you format a cell to reflect military time???
If you mean, for example, 2:15 AM and 5:30 PM appearing as 0215 and 1730,
respectively, you could give such cells the custom number format hhmm.
D
David Byrne
Hi to all,
You may care to check the following before you post.
http://www.timeanddate.com/library/abbreviations/timezones/military/z.html
You may care to check the following before you post.
http://www.timeanddate.com/library/abbreviations/timezones/military/z.html
H
Harlan Grove
David Byrne said:You may care to check the following before you post.
http://www.timeanddate.com/library/abbreviations/timezones/military/z.html
And you may consider checking
http://www.uscg.mil/reserve/pubs/helmsman/time.htm
I'd be willing to bet the latter is more relevant to the OP than the former.
But only the OP could say for sure.