Formula for SLA by excluding non-business hours, weekends (Fri & Sat) & Holiday

Hi Everyone,

I have a data of Incidents with Start date with time, End time with time.

Start time: 7/1/15 10:30 AM in C2 cell

End time: 7/9/15 5:33 PM in D2 cell

Holidays data in H2:H10.

Formula which I am using calculate SLA is

=(NETWORKDAYS(C2,D2,H$2:H$10)-1)*("18:00"-"09:00")+IF(NETWORKDAYS(D2,D2,H$2:H$10),MEDIAN(MOD(D2,1),"18:00","09:00"),"18:00")-MEDIAN(NETWORKDAYS(C2,C2,H$2:H$10)*MOD(C2,1),"18:00","09:00")

As the above formula consider Saturday & Sundays as weekends so the results are not ok for my case.
In my case I need to consider Friday & Saturdays as weekends. Pls suggest the correct formula.

Thanks,
Dhiraj

Thanks a lot daddylonglegs. This is working.

Regards,
Dhiraj