Hello All,

Please I need some assistance with a formula to calculate the time duration between 2 dates with the following conditions:

- weekends are excluded

- work hours are between 8AM and 5PM (any request received after 5PM is treated as next day

I used this formula to get the difference between the 2 dates, =TEXT(C3-A3,"d:h:mm:ss") but I've been stuck at factoring the conditions. Im using the formula to measure adherence to SLA.

Any help will be appreciated. Cheers