find total hours worked

[dkma]

Hi all, 

i have below Dataset.

the first two rows of the data belongs to 13-sep date., and the last two rows data belongs to 14-sep. how to segregate this to find total hours worked. 

The date shows as 13-sep because the Pin is on 13-Sep. 

EMP ID	Date	PinDate	Pin	Pout
11111	2021-09-13	2021-09-13	2021-09-13 00:00:00	2021-09-13 04:00:00
11111	2021-09-13	2021-09-13	2021-09-13 04:30:00	2021-09-13 07:31:00
11111	2021-09-13	2021-09-13	2021-09-13 23:49:00	2021-09-14 04:00:00
11111	2021-09-13	2021-09-13	2021-09-14 04:30:00	2021-09-14 07:30:00

How to make it correct. the last two rows should be counted towards 14-sep

[atcodedog05]

Hi @dkma 

Would reference to Pout for date be the right thing to do.

Workflow:

Hope this helps : )

[pdave87]

@dkma adding step 2 to what @atcodedog05 shared i.e. hours worked in screen-print below.

@atcodedog05 thanks for helping with the step 1. That's quickest solution and best way to solve it. Learning for me too.