Hello all,
I'm hoping you can help me out.
I would like to calculate staff meal deductions for each employee based on the number of hours they worked for that day.
I have the hours listed all on one page, per day, per employee.
I have the staff meal deductions range listed on another page in the workbook.
The range is as follows: *Please note anyone working over 8.00 hours is deducted a maximum of $2.40 for that shift/day.
<colgroup><col><col></colgroup><tbody>
</tbody>
I'm having trouble with the formula.
Thanks for looking!
I'm hoping you can help me out.
I would like to calculate staff meal deductions for each employee based on the number of hours they worked for that day.
I have the hours listed all on one page, per day, per employee.
I have the staff meal deductions range listed on another page in the workbook.
The range is as follows: *Please note anyone working over 8.00 hours is deducted a maximum of $2.40 for that shift/day.
Hours | Deduction |
1.00 | $0.30 |
1.25 | $0.38 |
1.50 | $0.45 |
1.75 | $0.53 |
2.00 | $0.60 |
2.25 | $0.68 |
2.50 | $0.75 |
2.75 | $0.83 |
3.00 | $0.90 |
3.25 | $0.98 |
3.50 | $1.05 |
3.75 | $1.13 |
4.00 | $1.20 |
4.25 | $1.28 |
4.50 | $1.35 |
4.75 | $1.43 |
5.00 | $1.50 |
5.25 | $1.58 |
5.50 | $1.65 |
5.75 | $1.73 |
6.00 | $1.80 |
6.25 | $1.88 |
6.50 | $1.95 |
6.75 | $2.03 |
7.00 | $2.10 |
7.25 | $2.18 |
7.50 | $2.25 |
7.75 | $2.33 |
8.00 | $2.40 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I'm having trouble with the formula.
Thanks for looking!