Forum Discussion
Excell spreadsheet
If I work 11hrs how do I move hrs above 8 to the next cell and any hrs over 2 to a third cell?
assuming A2 has total hours (11), you can have following formulae for next 3 cells
Cell B2 (8 hours or less) =IF(A2>8,8,A2)
Cell C2 (2 hours above 8) =IF(A2>=10,2,MAX(0,A2-8))
Cell D3 ( hours above 10) =MAX(0,A2-B2-C2)