# Thread: Convert mins into hours

1. ## Convert mins into hours

I work in a shipping and receiving dept. and was asked to convert my total minutes into hours. My total packages are 1,407 and my total minutes for all 1,407 packages is 62316 mins. What would be my average time of delivery hrs./mins.? Is there a formula for this also that I can use in excel to easily calculate this for me? Need help with this quickly if you can, thanks for your help in advance.

2. If you divide minutes by 60, you'll get hours. Therefore, 62316 minutes is 1038.6 hours, or 1036 hours and 36 minutes.

If you want to get the hours in decimal format, and assuming your total hours were in cell A1, use the following formula: =A1/60 (Format the cell containing the results as NUMBER, indicating the number of decimal places that you want.)

If you want to get hours and minutes as separate values, and the total minutes was in cell A1, you could use the following formulas:

Put this in cell B1, to get the hours: =QUOTIENT(A1,60).
Put this in cell C1 to get the minutes: =MOD(A1,60). (MOD gives you the "modulus" or remainder, which in this case would be the minutes left over after you factor out all of the whole hours.

3. You ask for the average time of delivery. Wouldn't that be 62316/1407 (total minutes divided by number of packages). This gives you an average of 44.3 minutes. You can convert this figure using Jim's formulas (though it's less than an hour anyway).
Or have I misunderstood what you're looking for....?

4. Originally Posted by access-mdb
You ask for the average time of delivery. Wouldn't that be 62316/1407 (total minutes divided by number of packages). This gives you an average of 44.3 minutes. You can convert this figure using Jim's formulas (though it's less than an hour anyway).
Or have I misunderstood what you're looking for....?
Access, I think you're right on this one.

5. try this formula:

=CONVERT(A1/B1,"mn","hr")/24 and format the cell as [h]:mm

HTH,
Maud

6. or, for lazy typing..
=A1/(24*60*B1)
..and format the cell as Time

zeddy

7. The reason zeddy's method works is Excel stores dates and times as a number, where one day (24 hours) = 1, so one hour = 1/24 and one minute = 1/(24*60).

cheers, Paul

8. Rob0511
It’s been quite a while since I’ve worked with Excel spreadsheets. In case you’d like to set up and maintain your Excel spreadsheet so you can determine future calculations
Start by using A2/(24*60*B2)

Rob0511.PNG