H
Hoov
I am making a payroll spreadsheet for my work, and I need some help coming
up with a consistent formula. There are three types of hours at work -
Regular, Nights and Weekends, and Overtime. These are in cells N4, O4, and
P4, respectively.
The Nights and Weekends cell (04) is what I need help with. Once the hours
in the "Regular" column hit 40, I need the Nights and Weekends hours to stop
accruing in the Nights and Weekends column, because they are now being paid
out of the Overtime column. I have all of the equations figured out for
Regular and Overtime, I just need Nights and Weekends to stop accruing once
the Regular hits 40 hours.
Here is an example with a hypothetical work schedule:
(B4)Saturday - 10 hours
(C4)Sunday - 10 hours
(D4)Monday - 10 hours
(E4)Tuesday Night - 10 hours
(F4)Wednesday - 10 hours
(G4)Thursday Night - 10 hours
(H4)Friday - 10 hours
OK - according to how my work operates, this worker would stop accruing both
Regular and Nights and Weekend Pay after Tuesday Night, because they are at
40 hours. So Wed, Thurs, and Fri will all be in the Overtime cell. I just
need to know how to tell the Nights and Weekends cell (O4) to stop accruing
hours once the Regular cell reaches 40 hours.
Please help if you are able to, and ask any questions if you need
clarification! Thanks!
up with a consistent formula. There are three types of hours at work -
Regular, Nights and Weekends, and Overtime. These are in cells N4, O4, and
P4, respectively.
The Nights and Weekends cell (04) is what I need help with. Once the hours
in the "Regular" column hit 40, I need the Nights and Weekends hours to stop
accruing in the Nights and Weekends column, because they are now being paid
out of the Overtime column. I have all of the equations figured out for
Regular and Overtime, I just need Nights and Weekends to stop accruing once
the Regular hits 40 hours.
Here is an example with a hypothetical work schedule:
(B4)Saturday - 10 hours
(C4)Sunday - 10 hours
(D4)Monday - 10 hours
(E4)Tuesday Night - 10 hours
(F4)Wednesday - 10 hours
(G4)Thursday Night - 10 hours
(H4)Friday - 10 hours
OK - according to how my work operates, this worker would stop accruing both
Regular and Nights and Weekend Pay after Tuesday Night, because they are at
40 hours. So Wed, Thurs, and Fri will all be in the Overtime cell. I just
need to know how to tell the Nights and Weekends cell (O4) to stop accruing
hours once the Regular cell reaches 40 hours.
Please help if you are able to, and ask any questions if you need
clarification! Thanks!