Hi Guys,
I am a bit confused as to how can I calculate time in the following cases. I need to calculate time worked before 5:00 and after 19:00 for the given shift start and end times along with the meal break times.
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>
Thanks for your help.
Asad
I am a bit confused as to how can I calculate time in the following cases. I need to calculate time worked before 5:00 and after 19:00 for the given shift start and end times along with the meal break times.
Start | Meal Start | Meal End | Meal Start | Meal End | Finish | Expected Answer |
03:57 | 08:34 | 09:26 | 11:04 | 11:56 | 13:44 | 01:03 |
13:46 | 15:34 | 16:26 | 19:04 | 19:50 | 22:59 | 03:13 |
<colgroup><col span="6"><col></colgroup><tbody>
</tbody>
Thanks for your help.
Asad