Hi, I am developing a time sheet and need help with the formulas for ST, OT & DT columns.
<tbody>
</tbody>In the course of a day:
In the above example I need:
Thank you in advance for any help.
Name | Start | Finish | Breaks | ST | OT | DT | |
John Doe | 7:00 | 23:00 | 1:00 | 8 | 2 | 5 | |
<tbody>
</tbody>
- the first 8 hours are at ST (straight time)
- the next 2 hours after 8 are at OT (over time)
- any hours after 10 hours are at DT (double time)
In the above example I need:
- ST to show 8 hrs
- OT to show 2 hrs
- DT to show 5 hrs
Thank you in advance for any help.