J
Jeremy
OK i am having a lot of trouble with this one. I am calculating overtime
hours for an ongoing job.
I get a total number of hours worked for every employee.
The first 40 hours of the week are straight time
Between 40 and 60 are time and a half
Over 60 hours are double time
Can someone help with the formulas? I think I have the end ones, but not
the middle one. See below
=IF(K31>=40,40,K31)
=IF(K31>60,K31-60)
hours for an ongoing job.
I get a total number of hours worked for every employee.
The first 40 hours of the week are straight time
Between 40 and 60 are time and a half
Over 60 hours are double time
Can someone help with the formulas? I think I have the end ones, but not
the middle one. See below
=IF(K31>=40,40,K31)
=IF(K31>60,K31-60)