Day Time difference removing holidays and weekends

Question

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 DateClosed DateResolution Time8/31/2023 21:239/6/2023 14:1365.858/31/2023 20:099/7/2023 14:5090.658/31/2023 19:359/5/2023 20:5449.39/3/2023 2:349/5/2023 14:3214.58/31/2023 23:229/5/2023 15:3740.259/1/2023 19:589/5/2023 13:1417.25

Deano478 · Answer

@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")

Cherub7210 · Answer

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

fledinku · Answer

Hello Cherub7210,

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

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