Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Aug 2016
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy 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. #2
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,728
    Thanks
    485
    Thanked 436 Times in 407 Posts
    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. #3
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,944
    Thanks
    157
    Thanked 182 Times in 175 Posts
    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....?
    The world is full of people whose notion of a satisfactory future is a return to the idealised past. Robertson Davies

  4. #4
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,728
    Thanks
    485
    Thanked 436 Times in 407 Posts
    Quote Originally Posted by access-mdb View Post
    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. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,793
    Thanks
    139
    Thanked 705 Times in 639 Posts
    try this formula:

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

    where A1 is your total minutes, B1 is your total packages

    HTH,
    Maud

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,188
    Thanks
    152
    Thanked 591 Times in 561 Posts
    or, for lazy typing..
    =A1/(24*60*B1)
    ..and format the cell as Time
    where A1 is your total minutes, B1 is your total packages

    zeddy

  7. #7
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,699
    Thanks
    59
    Thanked 1,066 Times in 991 Posts
    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. #8
    5 Star Lounger
    Join Date
    Jul 2012
    Posts
    1,006
    Thanks
    688
    Thanked 64 Times in 62 Posts
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •