# Thread: Need help with total monthly hours

1. ## Need help with total monthly hours

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

2. =SUM(D30:R30,D16:S16)
and format the cell [h]:mm:ss

3. Originally Posted by p45cal
=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. 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.

5. Originally Posted by p45cal
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. Originally Posted by dcope7
No, that gives military time.
Nonsense! It gives the number of hours in each cell.

7. What's the 12 about in this formula in cell D16:
=(D11+D15)+12
??

8. Originally Posted by p45cal
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. 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. 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 Last

#### Posting Permissions

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