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. |
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) |
All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com