jonnyp138
Board Regular
- Joined
- May 2, 2015
- Messages
- 50
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
Good afternoon,
I have to find a way of working out if incidents have breached SLA which I am having trouble seeing as some priority incidents are 24*7*365 such as Priority1 and Priority 2 yet Priority 3 & 4 the SLA clock runs from 7am-7pm Mon-Friday.
I have created 3 tables so far, 1 with the incident data which can be seen here (Not sure how to attach an xlsx file)
The Formula I have in Column D in table 1 is
=INDEX(Table3[SLA (Hours)],MATCH([@PriorityTxt],Table3[Priority],0))
The second table shows the Correlation of SLA Times
And Finally the 3rd table displays public holidays which should be excluded from the Priority 3 and 4 SLA times the same as weekends.
Can anyone help me with a formula that could work our whether or not the SLA has Breached?
Hopefully this is enough information to go on.
Thank you in advance
I have to find a way of working out if incidents have breached SLA which I am having trouble seeing as some priority incidents are 24*7*365 such as Priority1 and Priority 2 yet Priority 3 & 4 the SLA clock runs from 7am-7pm Mon-Friday.
I have created 3 tables so far, 1 with the incident data which can be seen here (Not sure how to attach an xlsx file)
The Formula I have in Column D in table 1 is
=INDEX(Table3[SLA (Hours)],MATCH([@PriorityTxt],Table3[Priority],0))
The second table shows the Correlation of SLA Times
And Finally the 3rd table displays public holidays which should be excluded from the Priority 3 and 4 SLA times the same as weekends.
Can anyone help me with a formula that could work our whether or not the SLA has Breached?
Hopefully this is enough information to go on.
Thank you in advance
Last edited:
