I am trying to get timecard w/o lunch and with lunch punches to total 12.25 regular hours before it is OT. I can get the hours to total calcuate using this formula:
=ROUND(SUM((F45-C45)-(E45-D45))*96,0)/4
For the OT after 12.25 I got this formula to work:
=IFERROR(MROUND((D45-C45+F45-E45+(C45>D45))*24-12.25,0.25),0)
The problem I can't seem to figure out is, I want it to stop calculating at 12.25 in the regular hours at 12.25 and not matter what I have tried can't seem to get it to work.