Forum Discussion
Pay times incorrect for calculation
I have start times and end times eg.. B...1156 and C...2330 and I need a formulae for regular hours and overtime; if any. =IF((C4-B4)<=800,(C4-B4)/100,8) this works for regular time IF((C5-B5)>=8...
The main issue is that your subtraction (C4 - B4) is treating times as numbers, not actual time values, which is causing incorrect calculations, especially for overtime.