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...
It'd be much easier if you entered the start and end time as real times 11:56 and 23:30
As it is now, you can use
=DOLLARFR(MIN(DOLLARDE(C4/100, 60)-DOLLARDE(B4/100, 60), 8), 60)
and
=DOLLARFR(MAX(DOLLARDE(C4/100, 60)-DOLLARDE(B4/100, 60)-8, 0), 60)
By the way, do you need to handle end times after midnight?