How to calculate SLA (weekends included)

Hi John, that is right. I had a formula in there before but it seems to only work on for weekdays and operates only 1 "Operating time"

I need 2 operating times and weekends.


here is the formula :

=IF(A2="","",WORKDAY(INT($B2),CEILING(MAX((INDEX($S$2:$S$9,MATCH($A2,$R$2:$R$9,0))-MAX($V$3-MAX($U$3,$B2-INT($B2)),0))/"8:00",0),1),$O$3:$O$10)+IF(MOD((INDEX($S$2:$S$9,MATCH($A2,$R$2:$R$9,0))-MAX($V$3-MAX($U$3,$B2-INT($B2)),0)),"8:00")>0,MOD(INDEX($S$2:$S$9,MATCH($A2,$R$2:$R$9,0))-MAX($V$3-MAX($U$3,$B2-INT($B2)),0),"8:00")+"9:00","17:00"))

Please find attached updated spreadsheet.