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 :

[TABLE="width: 456"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]User Name[/TD]
[TD] Login Time[/TD]
[TD] Logout Time[/TD]
[/TR]
[TR]
[TD]Bayleigh Osmer[/TD]
[TD]31.1.2018 5:57:06 PM[/TD]
[TD]31.1.2018 9:40:10 PM[/TD]
[/TR]
[TR]
[TD]Adam Davis[/TD]
[TD]31.1.2018 4:04:12 PM[/TD]
[TD]31.1.2018 8:14:23 PM[/TD]
[/TR]
[TR]
[TD]Adam Davis[/TD]
[TD]1.2.2018 11:58:59 AM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adam Davis[/TD]
[TD]1.2.2018 12:39:33 PM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adam Davis[/TD]
[TD]1.2.2018 12:49:08 PM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adam Davis[/TD]
[TD]1.2.2018 12:59:30 PM[/TD]
[TD]1.2.2018 1:10:05 PM[/TD]
[/TR]
[TR]
[TD]Adam Davis[/TD]
[TD]1.2.2018 1:14:58 PM[/TD]
[TD]1.2.2018 1:20:34 PM[/TD]
[/TR]
[TR]
[TD]Brittany Tharps[/TD]
[TD]31.1.2018 4:44:50 PM[/TD]
[TD]31.1.2018 6:22:59 PM[/TD]
[/TR]
[TR]
[TD]Brittany Tharps[/TD]
[TD]31.1.2018 6:56:06 PM[/TD]
[TD]31.1.2018 7:37:03 PM[/TD]
[/TR]
[TR]
[TD]Brittany Tharps[/TD]
[TD]31.1.2018 8:10:37 PM[/TD]
[TD]31.1.2018 8:51:08 PM[/TD]
[/TR]
[TR]
[TD]Brittany Tharps[/TD]
[TD]31.1.2018 9:06:53 PM[/TD]
[TD]31.1.2018 11:27:16 PM[/TD]
[/TR]
</tbody>[/TABLE]

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