Formula for finding weekend hours

[PNC97]

Hello All,

Thanks for looking into it.

I trying to figure out a solution like if in a particular week if any on the ee worked for two weekends in week should populate in one row and if any ee worked for any one weekend in a week should populate for one weekend then those should be other row I tried in below approach but no luck.

Attached a copy of samples.

Thanks in advance. looking for a Alteryx workflow

[DataNath]

Hey @PNC97 are you able to expand on the requirement? Not sure I understand the request, sorry. Would be great if you could provide an expected outcome as a supplement, too. Perhaps what you'd imagine the output to be for one of the IDs or something? Cheers

[PNC97]

Hi @DataNath thanks for the response.

I've attached the expected output in the sheet: output.

[DataNath · Accepted solution]

How does this look @PNC97? If not I'm afraid I still don't fully understand the logic.