How to calculate SLA (weekends included)

Sorry I am new to all of this.

Did I not show it in CASE 1? of the sample workbook v3? it crosses from a weekday to a weekend.

or case 3 - from weekend to weekday

There is a formula in row 8 down which the OP appears to have overwritten. Perhaps reinstate the formula (which appears to be a "standard" one for this type of problem) and there will a "starter" for us.

Column C is column B with the SLA hours added, allowing for weekdays, weekends and daily working hours.

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.