| 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 | |||
Threaded Mode
