| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert Military Time to minutes?
I'm working on a spreadsheet and have to log each associates time. The time
is logged in Military Time and I need to know what formula I can use to convert the hours to minutes. |
|
#2
|
|||
|
|||
|
Rachael wrote...
I'm working on a spreadsheet and have to log each associates time. The time is logged in Military Time and I need to know what formula I can use to convert the hours to minutes. Do you mean entries like 0345 and 2510 would be 3 hours 45 minutes and 25 hours 10 minutes, respectively? If so, =LEFT(EntryInMilitaryTime,LEN(EntryInMilitaryTime)-2)*60 +RIGHT(EntryInMilitaryTime,2) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Adding minutes to time | Excel Discussion (Misc queries) | |||
| How do I convert times from hours to minutes? | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
| convert minutes into hours:minutes | Excel Worksheet Functions | |||
Linear Mode
