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,479
    Thanks
    459
    Thanked 410 Times in 382 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,763
    Thanks
    150
    Thanked 161 Times in 154 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....?
    What was the greatest thing before sliced bread?

  4. #4
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,479
    Thanks
    459
    Thanked 410 Times in 382 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,688
    Thanks
    122
    Thanked 668 Times in 609 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
    2,949
    Thanks
    140
    Thanked 519 Times in 495 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,356
    Thanks
    52
    Thanked 1,016 Times in 945 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
    991
    Thanks
    681
    Thanked 62 Times in 61 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
  •