find total hours worked

Question

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 IDDatePinDatePinPout111112021-09-132021-09-132021-09-13 00:00:002021-09-13 04:00:00111112021-09-132021-09-132021-09-13 04:30:002021-09-13 07:31:00111112021-09-132021-09-132021-09-13 23:49:002021-09-14 04:00:00111112021-09-132021-09-132021-09-14 04:30:002021-09-14 07:30:00

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

pdave87 · Answer

@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.

atcodedog05 · Answer

Hi @dkma

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

Workflow:

Hope this helps : )

Pout.yxmd