working hours cal

Hello Everyone,

I'm trying to find a solution for the total working hours in a week including Saturday's and Sunday's if worked.

Example:

Lets X person worked for two weeks form 07/04/2021 to 07/17/2021. Now I'm trying to find out the hours X worked in individual week.

I will really appreciate if I can get some direction.
Please find the attached samples.

Thanks in advance 🙂

Alteryx Example.xlsx

Parse

Date Time

Time Series

Accepted answers

atcodedog05

Hi @PNC97

Hope this is what you are looking for.

Workflow:

I have made 2 variations in upper branch week starts from Monday and lower branch week starts from Sunday.

1. Using formula to calculate first day of week. And convert working hours to seconds so that it can be summed up.

2. Using summarize tool groupby ID, Week start and sum of seconds.

3. Using formula tool to bring it to 00Hrs 00Mins format.

Hope this helps : )

Worked Hours.yxmd

All comments

BA02

Try:

In the Formula tool, use the expression DateTimeFormat(<date/time>, "%U") -- if you want the week to start from Sunday

or DateTimeFormat(<date/time>, "%W") -- Monday start of the week. This would return the week number of the year which you can then leverage on to group your data by.

You can also refer to https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-Week-Number-using-DateTimeFormat-is-incorrect/td-p/46192 to use another way around for getting the week number.

Group the data by their week number and IDs and then sum the hours worked using the summarize tool. Hope this helps!

PNC97

@BA02 Can you help me with the workflow?

BA02

@atcodesog05 this is perfect! @PNC97 hope this works for you.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280