Good Day!
How can I compute the number of hours between a specific range,
For example, an employee has timed in at 6:00 pm then timed out at 3:00 am the next day. What formula can I use to compute the number of hours that is only within the Night Differential, 10:00 pm to 6:00 am.
Note:
Night Differential can be changed based on the policy of the user.
What formula should I use on the Night Differential and Night Differential OT column?
Thank you very much.
<tbody>
</tbody>
How can I compute the number of hours between a specific range,
For example, an employee has timed in at 6:00 pm then timed out at 3:00 am the next day. What formula can I use to compute the number of hours that is only within the Night Differential, 10:00 pm to 6:00 am.
Note:
Night Differential can be changed based on the policy of the user.
What formula should I use on the Night Differential and Night Differential OT column?
Thank you very much.
Company Policy | |||||
Start Time | 6:00 pm | End Time | 3:00 am | ||
Night Differential Start | 10:00 pm | Night Differential End | 6:00 am | ||
Employee Timesheet | |||||
Time In | Time Out | Regular Hours | Regular OT | Night Differential | Night Differential OT |
6:00 pm | 3:00 am | 4 hours | 0 | 5 hours | 0 |
6:00 pm | 5:00 am | 4 hours | 0 | 5 hours | 2 hours |
6:00 pm | 7:00 am | 4 hours | 1 hour | 5 hours | 3 hours |
<tbody>
</tbody>