Hi Everyone,

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

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

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

Formula which i was using to calculate SLA was =(NETWORKDAYS(C2,D2)-1)*("18:00"-"08:00")+IF(NETWORKDAYS(C2,D2),MEDIAN(MOD(D2,1),"18:00","08:00"),"18:00")-MEDIAN(NETWORKDAYS(C2,C2)*MOD(C2,1),"18:00","08:00")

The TTR is 67:03:07

Now the above formula excludes just the week ends and non-business hours.

But i need to exclude the bank holidays as well.

Business hours are 08:00:00 to 18:00:00.

Kindly help me towards Resolution.

Regards
Kokila.S