Help with a formule

[Dave]

How would you format a cell to reflect military time???

 

[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

 

[Harlan Grove]

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.

 

[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

 

[Harlan Grove]

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.