Formula Help for Timecard


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:


For the OT after 12.25 I got this formula to work:


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.



Selected Answer

I think this is what you were looking for:


This formula limits the maximum result to 12.25



Worked perfectly, thank you so much
blinhart (rep: 2) Apr 18, '18 at 8:45 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login