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

I appreciate all the help but I guess I'm just not getting it. I trying to
create a time sheet and I want to use military time to represent the start
time and end time.

"Spiky" wrote:

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