Formula Help for Timecard

0

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.

Answer
Discuss

Answers

0
Selected Answer

I think this is what you were looking for:

=MIN(ROUND(SUM((F45-C45)-(E45-D45))*96,0)/4,12.25)

This formula limits the maximum result to 12.25

Discuss

Discussion

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