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.
Excel can easily handle military time without any adjustments. But it
does need to be entered with a colon, otherwise it doesn't recognize
"time" at all.
To skip the colon, you would need to be able to use other cells with
more complex formulas to be able to add up the time for a time sheet.
This will turn "1800" or "0600" into the appropriate times so Excel
can understand them:
=TIME(LEFT(A1,LEN(A1)-2),RIGHT(A1,2),)
Then you can use that formula on both start and end times and subtract
to get hours worked. Assuming B1 is end time and A1 is beginning time.
=TIME(LEFT(B1,LEN(B1)-2),RIGHT(B1,2),)-
TIME(LEFT(A1,LEN(A1)-2),RIGHT(A1,2),)
And then you can format the output cell as "hhmm" to get that to show
without the colon.