Hi, I need help on how to calculate SLA uptime in Excel that have two working hours.
I have two different working hours in one day. For Example, in one day is working time is from 8.30am - 5.30pm and at night 10.30pm-6.30am. What formula to use combining this two different times? Also it exclude weekends and holidays.
I used this formula but this is only for 1 working hours. I don't know how to combine with two working hours.
=(NETWORKDAYS(A1,B1)-1)*("17:30"-"08:30")
+IF(NETWORKDAYS(B1,B1),MEDIAN(MOD(B1,1),"17:30"
,"08:30"),"17:30")-MEDIAN(NETWORKDAYS(A1,A1)
*MOD(A1,1),"17:30","08:30")
Appreciate if you guys can assist me. Thank you.
Bookmarks