Find out duration from two Datetime excluding weekend day and times

Hello Team,

I have a scenario in which I want to find the difference between two Datetime variables and the criteria is we should not include weekends I have tried so many ways but am not able to figure this out.

Raised FirstResponse

05/26/2022 06:51 05/28/2022 13:54

Output:

41:09

excluded 13:54PM hours

Data Challenge

Academy

Community

Off-Topic

Alteryx Practice

ADAPT

Contest

Accepted answers

Amol_Telore

@ShivAlt Updated the workflow to output data in decimal format.

Time_Difference_Excluding_Weekend.yxmd

All comments

Amol_Telore

Hi @ShivAlt

Here is my solution. Let me know in case of any questions.

Time_Difference_Excluding_Weekend.yxmd

ShivAlt

Can't we have to last output in decimal or numbers?(41.09)

Amol_Telore

@ShivAlt Updated the workflow to output data in decimal format.

Time_Difference_Excluding_Weekend.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703