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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Company Policy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Start Time[/TD]
[TD]6:00 pm[/TD]
[TD][/TD]
[TD][/TD]
[TD]End Time[/TD]
[TD]3:00 am[/TD]
[/TR]
[TR]
[TD]Night Differential Start[/TD]
[TD]10:00 pm[/TD]
[TD][/TD]
[TD][/TD]
[TD]Night Differential End[/TD]
[TD]6:00 am[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee Timesheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Time In[/TD]
[TD]Time Out[/TD]
[TD]Regular Hours[/TD]
[TD]Regular OT[/TD]
[TD]Night Differential[/TD]
[TD]Night Differential OT[/TD]
[/TR]
[TR]
[TD]6:00 pm[/TD]
[TD]3:00 am[/TD]
[TD]4 hours[/TD]
[TD]0[/TD]
[TD]5 hours[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6:00 pm[/TD]
[TD]5:00 am[/TD]
[TD]4 hours[/TD]
[TD]0[/TD]
[TD]5 hours[/TD]
[TD]2 hours[/TD]
[/TR]
[TR]
[TD]6:00 pm[/TD]
[TD]7:00 am[/TD]
[TD]4 hours[/TD]
[TD]1 hour[/TD]
[TD]5 hours[/TD]
[TD]3 hours[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Company Policy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Start Time[/TD]
[TD]6:00 pm[/TD]
[TD][/TD]
[TD][/TD]
[TD]End Time[/TD]
[TD]3:00 am[/TD]
[/TR]
[TR]
[TD]Night Differential Start[/TD]
[TD]10:00 pm[/TD]
[TD][/TD]
[TD][/TD]
[TD]Night Differential End[/TD]
[TD]6:00 am[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee Timesheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Time In[/TD]
[TD]Time Out[/TD]
[TD]Regular Hours[/TD]
[TD]Regular OT[/TD]
[TD]Night Differential[/TD]
[TD]Night Differential OT[/TD]
[/TR]
[TR]
[TD]6:00 pm[/TD]
[TD]3:00 am[/TD]
[TD]4 hours[/TD]
[TD]0[/TD]
[TD]5 hours[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6:00 pm[/TD]
[TD]5:00 am[/TD]
[TD]4 hours[/TD]
[TD]0[/TD]
[TD]5 hours[/TD]
[TD]2 hours[/TD]
[/TR]
[TR]
[TD]6:00 pm[/TD]
[TD]7:00 am[/TD]
[TD]4 hours[/TD]
[TD]1 hour[/TD]
[TD]5 hours[/TD]
[TD]3 hours[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]