Excell spreadsheet

Copper Contributor
If I work 11hrs how do I move hrs above 8 to the next cell and any hrs over 2 to a third cell?
1 Reply

@gbat228836 

 

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)