Working Hours calculation excluding weekends and Holidays

[sekarsdream]

Hello ,

I have a data set in which i want to find the TAT between two Date time variable the creteria is we should not include weekends also we should exclude #holiday list which i have, also the working hours is in between 9:00 to 18:00 .I have tried so many ways but not able to figure this out. for example as below one.. 

Timestamp1        Timestamp 2

06/16/2016 7:04:03 AM  06/20/2016 7:52:53 AM

We have  18th and 19th is weekends and 17th is holiday ,can anyone help me on this?

[rurquizo]

I'm trying to adjust your workflow to fit my business needs. Can you please explain the formula logic of this?