Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell as military time
I want to type in 0700 in a cell and press <tab to go to the next cell and
it will auto format it like 07:00 (military time). ex: type in 1400 and it display as 14:00, etc. In other words, I want to be lazy and not have to type the colon. How do I need to format the cell? Thanks... Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
time calculation with military time | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
calculating with a time format cell | Excel Worksheet Functions |