This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?