T
Tiggerco
How do I set up military time? When I enter "0800" and enter, it converts to
"800".
"800".
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Carole O
You could format the cell as text, or enter '0800. You can still add,
subtract, etc in that format.
Carole O
subtract, etc in that format.
Carole O
D
Dave Peterson
Working with numbers that are text can be difficult. Working with times becomes
even more difficult.
even more difficult.
D
Dave Peterson
I would enter the time as time.
But then format that cell as: hhmm
If you really want to avoid typing that colon, Chip Pearson has some VBA code
that you may want to tweak:
http://www.cpearson.com/excel/DateTimeEntry.htm
But then format that cell as: hhmm
If you really want to avoid typing that colon, Chip Pearson has some VBA code
that you may want to tweak:
http://www.cpearson.com/excel/DateTimeEntry.htm
D
David Biddulph
Enter 08:00