Formula for finding weekend hours

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

Test - Copy.xlsx

Datasets

Developer

Reporting

Output

Custom Tools

Parse

Date Time

Common Use Cases

Transformation

Help

Join

Preparation

Data Investigation

Time Series

Prescriptive Analytics

Accepted answers

DataNath

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

Workout weekend hours.yxmd

All comments

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.

Test - Copy.xlsx

DataNath

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

Workout weekend hours.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703