Hi everyone...I need help as quickly as possible...I am calculating SLA response time between two dates. The hours are M-F 8am-6pm and Sat 8am-3pm...I've got that portion figured out...now I need to remove holidays that may fall within that range...I have a list of dates I can refer to, but cannot figure out how to work it into the formula I have below.

=((SUM(INT((WEEKDAY(P2-{2,3,4,5,6})+INT(T2)-INT(P2))/7))-1)*("18:00"-"8:00")+IF(OR(WEEKDAY(T2)=1,WEEKDAY(T2)=7),"18:00",MEDIAN(MOD(T2,1),"18:00","8:00"))-MEDIAN((AND(WEEKDAY(P2)<>1,WEEKDAY(P2)<>7))*MOD(P2,1),"8:00","18:00")+(SUM(INT((WEEKDAY(P2-{7})+INT(T2)-INT(P2))/7))-1)*("15:00"-"8:00")+"15:00"-MEDIAN((WEEKDAY(P2)=7)*MOD(P2,1),"8:00","15:00"))*24

P2 is the date&time the call was generated and T2 is the date&time our tech arrived on site. I need to remove the time (within our work hours) that fall on any of the holidays in the array.

EFF_DATE_TIME ARRIVE_DATE_TIME TOT_HRS
2/2/12 9:47 AM 2/13/12 9:00 AM 83.22

Does anybody have a solution? Any assistance will be greatly appreciated!!