Hi guys!

My problem on day shift overtime calculation formula.

My sheet is set up as follow.
C9 in, D9 out, E9 =SUM(D9-C9+IF(C9>D9,1)) F9 normal hrs. G9 Overtime

E9 works fine but G9 my formula keeps giving me different daily totals.

My night shift is set up the same my formula on E9 keeps the daily total on 0:00
and G9 my overtime I simply can't find a formula to work.

Any help would be greatly appreciated so I can save the little hair that's left on my head

Kind Regards