Forum Discussion
Solved
Add time sheet hours
I am trying to add the hours up, and once block I16 hits 40 hours would like the remaining hours to populate in block I17.
The formula that I used to get total hours per each day: =if(g6>h6,h6+1,h6)-g6
The formula that I used to get total hours in block I16: =sum(I6:I15
A shorter formula in I6:
=MOD(H6-G6, 1)
Edited to correct mistakes!
In I16:
=MIN(SUM(I6:I15), 40/24)
In I17:
=MAX(SUM(I6:I15)-40/24, 0)
- I was unable to get these formulas to work.
