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,...
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.
- Thank you, it worked perfectly.