Jul 11 2019 07:39 PM
Jul 11 2019 09:51 PM
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)