| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I caculate 24 hour military times
The above fomulae (Bob's and mine) only work for hourly times as in the
example given. But for other times an adjustment is needed eg 2115 to 800 should give 1045 (not 1085). This should work for all times entered in "hhmm" format: =--TEXT(MOD(TEXT(B1,"0\:00")-TEXT(A1,"0\:00"),1),"hhmm") |
| Reply |
| 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 | |||
Hybrid Mode
