TN0410
New member
- Joined
- May 13, 2022
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Microsoft 365 MSO Version 2203
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
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