Hello all! I have had no luck finding a time sheet set up like I need. I have tried combining formulas I found online, only to make things worse.
Criteria:
<tbody>
</tbody>
Example:
<tbody>
</tbody>
Criteria:
| Sunday is always overtime |
| Shift differential is 0.15% and begins for hours 5:00pm to 12:00am |
| Shift differential is 0.30% and begins for hours 12:00am to 8:00am |
| Only the fields in Green should ever have to have input |
| Overtime only begins once 40 hours are worked, regardless of how many hours worked per day Only need to adjust the hours worked and hourly pay to get all fields filled out |
<tbody>
</tbody>
Example:
| Work Start | Lunch Start | Lunch End | Work End | Regular Hours Worked | Overtime Worked | 2nd Shift Worked | 2nd Shift Overtime | 3rd Shift Worked | 3rd Shift Overtime | Total Hours Worked | Holiday Pay | Regular Rate | $27 | |
| Sunday | 8:00 AM | 12:00 PM | 1:00 PM | 6:00 PM | 8.00 | 1.00 | 9.00 | Overtime Rate | $40.50 | |||||
| Monday | 8:00 AM | 12:00 PM | 1:00 PM | 6:00 PM | 8.00 | 1.00 | 9.00 | 2nd Shift Worked | $31.05 | |||||
| Tuesday | 8:00 AM | 12:00 PM | 1:00 PM | 6:00 PM | 8.00 | 1.00 | 9.00 | 2nd Shift Overtime | $46.58 | |||||
| Wednesday | 8:00 AM | 12:00 PM | 1:00 PM | 6:00 PM | 8.00 | 1.00 | 9.00 | 3rd Shift Worked | $35.10 | |||||
| Thursday | 8:00 AM | 12:00 PM | 1:00 PM | 6:00 PM | 4.00 | 4.00 | 1.00 | 9.00 | 3rd Shift Overtime | $52.65 | ||||
| Friday | 8:00 AM | 12:00 PM | 1:00 PM | 6:00 PM | 8.00 | 1.00 | 9.00 | |||||||
| Saturday | 0.00 | |||||||||||||
| Totals | 28.00 | 20.00 | 3.00 | 3.00 | 0.00 | 0.00 | 54.00 | 0.00 | ||||||
| $756.00 | $810.00 | $93.15 | $139.73 | $0.00 | $0.00 | $1,798.88 | 0.00 | |||||||
| Green = Fields that will be adjusted | ||||||||||||||
| Red = Fields that need to be set using a forumla | ||||||||||||||
| Gray = Non changing |
<tbody>
</tbody>
