Hello Team,
Can anyone please simplify the below requirement?
I am looking for a total worker working hours from the time of start of the shift to the end of the shift.
Please add the formulae or create a template and share with me. Sample data are shown below :
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I have total 200 workers.
Regards,
Heera
Can anyone please simplify the below requirement?
I am looking for a total worker working hours from the time of start of the shift to the end of the shift.
Please add the formulae or create a template and share with me. Sample data are shown below :
User Name | Login Time | Logout Time |
Bayleigh Osmer | 31.1.2018 5:57:06 PM | 31.1.2018 9:40:10 PM |
Adam Davis | 31.1.2018 4:04:12 PM | 31.1.2018 8:14:23 PM |
Adam Davis | 1.2.2018 11:58:59 AM | |
Adam Davis | 1.2.2018 12:39:33 PM | |
Adam Davis | 1.2.2018 12:49:08 PM | |
Adam Davis | 1.2.2018 12:59:30 PM | 1.2.2018 1:10:05 PM |
Adam Davis | 1.2.2018 1:14:58 PM | 1.2.2018 1:20:34 PM |
Brittany Tharps | 31.1.2018 4:44:50 PM | 31.1.2018 6:22:59 PM |
Brittany Tharps | 31.1.2018 6:56:06 PM | 31.1.2018 7:37:03 PM |
Brittany Tharps | 31.1.2018 8:10:37 PM | 31.1.2018 8:51:08 PM |
Brittany Tharps | 31.1.2018 9:06:53 PM | 31.1.2018 11:27:16 PM |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I have total 200 workers.
Regards,
Heera