General Discussions

Discuss any topics that are not product-specific here.

Find out duration from two Datetime excluding weekend day and times

ShivAlt
6 - Meteoroid

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

3 REPLIES 3
Amol_Telore
11 - Bolide

Hi @ShivAlt 

 

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

 

Amol_Telore_0-1657617273966.png

 

ShivAlt
6 - Meteoroid

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

Amol_Telore
11 - Bolide

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

Labels