View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default change regular 24 hour format to military time in excel

...
I am trying to create a format for military time in excel


What are you planning on doing with these entries? If it is just for
display, you could just format it to forced 4-digit numbers, "0000".
Don't worry about date/time format.

If you are planning on adding or subtracting as time and date values,
that will be harder. Excel needs it to be entered as a time, with the
colon. Otherwise it can't tell the difference since, for example,
today at 1800 is actually the number 39611.75 to Excel. You could
enter "1800" in one cell and have other cells reformat it to time for
any operation you need to calculate.