Reply With Quote
=SUM(D30:R30,D16:S16)
and format the cell [h]:mm:ss
=SUM(D30:R30,D16:S16)
and format the cell [h]:mm:ss
Originally Posted by p45cal
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.
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 12:43 PM.
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.
Nonsense! It gives the number of hours in each cell.
What's the 12 about in this formula in cell D16:
=(D11+D15)+12
??
I tried it in E11, It showed as 16:00:00 that's why I have it with the am/pm
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.
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
Posting Permissions
Bookmarks