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,405
    Thanks
    447
    Thanked 404 Times in 376 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,725
    Thanks
    147
    Thanked 156 Times in 149 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....?
    Talk is cheap because supply exceeds demand

  4. #4
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,405
    Thanks
    447
    Thanked 404 Times in 376 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,637
    Thanks
    115
    Thanked 650 Times in 592 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,826
    Thanks
    136
    Thanked 482 Times in 459 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,191
    Thanks
    48
    Thanked 985 Times in 915 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
    966
    Thanks
    661
    Thanked 58 Times in 57 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
  •