Day Time difference removing holidays and weekends

[Cherub7210]

Good day,

I do have a data set of dates - created and close date. I would like to calculate the difference with these dates removing weekends and holidays 

Below is the sample Data 

Created Date	Closed Date	Resolution Time
8/31/2023 21:23	9/6/2023 14:13	65.85
8/31/2023 20:09	9/7/2023 14:50	90.65
8/31/2023 19:35	9/5/2023 20:54	49.3
9/3/2023 2:34	9/5/2023 14:32	14.5
8/31/2023 23:22	9/5/2023 15:37	40.25
9/1/2023 19:58	9/5/2023 13:14	17.25

[aliabedi]

Hello Cherub7210,

Please refer to the article below; hopefully, it will prove helpful.

Solved: Calculate difference between two dates and exclude... - Alteryx Community

[Cherub7210]

Thank you for sharing. This solution only addresses the number of days between the two. For this scenario, i was hoping to get guidance to get it as hours difference between the two dates

[Deano478]

@Cherub7210 you can adapt that solution from the post then use a formula like so for the hours part:

DateTimeDiff([Closed Date], [Created Date], "hour")