How do I convert Military Time to minutes?

R

Rachael

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.
 
H

hrlngrv

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.
Click to expand...

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert string to military time string 14
military time set up 6
Time Calculation 3
Convert time to military time? 3
Calculating Difference Between Two Times in General Format 5
Need formula for calculating time 2
Converting time to Minutes 2
Time In-Time Out/No. of Units 13

Top