Total worker duration

[Heera]

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 :

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

 

[Heera]

Thank you Dave. After considering both the formulae, i am able to get the required information. Thank you so much for your help.

Regards,
Heera