I need help in getting a formula to work in overtime H8 to H13 column, where it takes any hours worked over 8 hours into the overtime hours. Into Time 1/2 (T1/2) cell and double time (DT) cell.
Where any overtime is transferred as the first two hours are @ Time & 1/2 - I8:I13, the rest of the overtime hours are put into cells J8:J13 as double time.
All day Saturday, the first two hours worked on a Saturday is Time & 1/2 (T1/2), then the rest of the hours worked on a Saturday are double time (DT)
There is no trading on a Sunday. Is it possible to have an IF or nested IF formula that works in these cells?
I have attached the excel table that I am struggling with.