| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I caculate 24 hour military times
Hi Tom,
Two steps: 1) Enter time with a colon separating the hours and minutes (18:00 or 4:00), and 2) Format the cells in military time {Press Ctrl 1 or go to the Format Menu - Cells - Number tab - Time [select the military format you want (ex: 13:00) - press OK]}. Hope this helps. "Tom" wrote: How can I caculate military times such as 1800 hours to 400 hours for a time sheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a formula to muliply hours times dollars per hour? | Excel Discussion (Misc queries) | |||
| How to I convert standard time to Military or 24 hour format? | Excel Discussion (Misc queries) | |||
| How do I sum times to get a total hour value? If I add up to 24 h. | Excel Discussion (Misc queries) | |||
| subtracting times using 24 hour clock | Excel Worksheet Functions | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Threaded Mode
