I am writing a report to show calls which have passed or failed an SLA
There Are 5 priorties which need to be worked out with different response times
p1 5 mins p2 1 hr p3 4 hr p4 1 day p5 2 days
I am trying to work out the actual respnse time but the formula I have returns blank data.
I would like to know if it would be possible to add the set time onto the arrival time to work out the required response time, and if poss how to do it.
There Are 5 priorties which need to be worked out with different response times
p1 5 mins p2 1 hr p3 4 hr p4 1 day p5 2 days
I am trying to work out the actual respnse time but the formula I have returns blank data.
I would like to know if it would be possible to add the set time onto the arrival time to work out the required response time, and if poss how to do it.