Hello, I need urgent help on this matter.
The formula in L works correctly and up to a point, except when the hours change between Shift Length D8 to 10:00, and in Hours Worked G8 shows 11:00, but in Scheduled overtime L8 it shows 01:12 instead of 02:12
=MAX(0, IF(D3>=TIME(10,0,0)...