| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
0100 (24 hour) time - Which format??
Hi,
I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format type that retains these numbers as four digits (allows me to go to 2400) . Which format is it - I have tried several and it drops the first zero(0) off. Cheers Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| display time in 12 hour format | Excel Worksheet Functions | |||
| 24 hour time format help with 00:00 calculation | Excel Discussion (Misc queries) | |||
| How to I convert standard time to Military or 24 hour format? | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Threaded Mode
