Hello,

Thanks in Advance!

I have SLA of 24 hour to resolve a ticket, for that i need the SLA time and date excluding weekends , holidays, multiple non - working hour
If ticket comes at non working hour or at holiday or weekend it should count from the working hour/day.
Holiday schedule
2/18/2019
5/27/2019
7/4/2019
7/5/2019

Working hour in a day-
12:00 AM 3:30 AM
8:00 AM 5:00 PM
6:30 PM 11:59 PM

Cell A1 consist - 3/27/2019 12:00 PM

Cell A2 - SLA time (Should be 3/28/2019 7:30) Need formula to calculate this time.

Thanks.