Yes, the times will be going pass 24:00 hrs. Schedule times are.......0600
to 1400, 1400 to 2200 and 2200 to 0600.

"Meebers" wrote:

I think you will find it easier in the long run by using the standard time
format as 18:00 for your entries. Will the times be going past 24:00 hrs.
For example if somebody had duty from 21:00 to 03:00 the next day or duty
longer than a 24 hr period let us know and we can generate a formula for
you. For example purposes a1 = start time b1= end of duty. Total will be
in C1 (where the formula will be). ?


"kidsmeasy" wrote in message
...
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.