Row A has employee names
Row B through H (irrelevant) lists the hours worked per day.
Row I has the total hours worked per week PER employee.
How do I build this formula?
End goal, I want everyone's overtime, qty hours worked over 40, to be totaled for that week.
I'm thinking something like... IF I1 is greater than 40, then I1 minus 40... ELSE ignore I1... then move to I2, I3, I4, I5, etc. and add them all up in one formula.
BTW: this formula will be used with different groups. Some groups have 5 employees. Some groups have 10 or more employees.
thanks!
Row B through H (irrelevant) lists the hours worked per day.
Row I has the total hours worked per week PER employee.
How do I build this formula?
End goal, I want everyone's overtime, qty hours worked over 40, to be totaled for that week.
I'm thinking something like... IF I1 is greater than 40, then I1 minus 40... ELSE ignore I1... then move to I2, I3, I4, I5, etc. and add them all up in one formula.
BTW: this formula will be used with different groups. Some groups have 5 employees. Some groups have 10 or more employees.
thanks!
Last edited: