Hi,
I've been trying all morning to work out a formula with no luck (will prob take someone on here 5 minutes to solve).
I have the current formula to calculate the following:
=IF(O3<8.8,0,IF(O3<9.89,0.5,IF(O3<11,1,IF(O3<12.16,0.5,0))))
<tbody>
Operator Total Shift Hours Booked
Less than...