Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 24

Thread: Need help with total monthly hours

  1. #1
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10

    Need help with total monthly hours



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Does anyone know of a formula that will total monthly hours for multiple cells: Example: D16:S16+D30:R31???
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    =SUM(D30:R30,D16:S16)
    and format the cell [h]:mm:ss

  3. #3
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10
    Quote Originally Posted by p45cal View Post
    =SUM(D30:R30,D16:S16)
    and format the cell [h]:mm:ss

    Thank you for your response but, I have tried that. The total should be 103:12:00 hrs for the month. I have formulas in cells D11:S11and D25:R31 to total worked hrs for the day and D15:S15, D29:r29 to total travel times. Not sure that has anything to do with getting the total hrs for the month.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    Temporarily format all the cells included in your sum formula [h]:mm:ss and visually chack that they contain the values you expect. Especially cells D16 and H16 among others.
    Last edited by p45cal; 2021-01-15 at 01:43 PM.

  5. #5
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10
    Quote Originally Posted by p45cal View Post
    Temporarily format all the cells included in your sum formula [h]:mm:ss and visually chack that they contain the values you expect. Especially cells D16 and H16 among others.



    No, that gives military time. I think I've tried every formula there is. The highlighted cell will give correct totals when I don't have the formula in the D11 and D30 cells but I need that to get the daily hours.

  6. #6
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by dcope7 View Post
    No, that gives military time.
    Nonsense! It gives the number of hours in each cell.

  7. #7
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    What's the 12 about in this formula in cell D16:
    =(D11+D15)+12
    ??

  8. #8
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10
    Quote Originally Posted by p45cal View Post
    Nonsense! It gives the number of hours in each cell.


    I tried it in E11, It showed as 16:00:00 that's why I have it with the am/pm

  9. #9
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10
    If there is no times in the cells then there are no hours worked. I have all cells needed formatted. Weekends there is no work or days absent but those change every month and I don't want to have to keep re-formatting the sheet every month.

  10. #10
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10
    I key in the pick up times and arrival times, I have the billable rows calculate the hours worked. I key in the departure and return times, travel time calculate and row 16 calculates rows 11 and 15

Page 1 of 3 1 2 3 LastLast

Posting Permissions

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