Sumif for payroll

[Guest]

I want to track overtime pay. I want it to sum Regular time up to 40 hours
and anything over 40 hours as overtime pay.

I tried something like this equation, but it is incorrect:
=SUMIF(((M22-40,)+(O22-40)),"<1")


Week 1 Week 2 Regular Overtime
Shifts Hrs Shifts Hrs
4 48 3 36

 

[Guest]

Try this for your regular hours:
=MIN(40,M2)+MIN(40,O2)
and then this for the overtime
=(M2+O2)-P2

This assumes that your 48 is in M, the 36 in O and that Regular goes into P,
with the overtime calculation in column Q.
would show up as

.... L M N O P Q
4 48 3 36 76 8

 

[JE McGimpsey]

One way:

Regular: = MIN(40,M22)+MIN(40,O22)

OT: =MAX(0,M22-40) + MAX(0,O22-40)