I am trying to calculate the total number of overtime hours worked by staff each week. I have a formula that seems to do the job OK, but I feel there could be a better or more concise way to write it.
Basically I have a list of all the staff, and the number of hours they have worked that week. My
SUMIF() finds the hours over
40, adds them together, and then subtracts
40 for each of the staff with overtime.
Is there a way to subtract values based on a SumIf range, rather than having to include the
40*COUNTIF()... ? Something like
=SUMIF(B2:B13,">40",[B2:B13]-40) (I know this doesn't work, it's just how I pictured it when I tried it out).