SLA find out

[Anonymous]

Number	Requested Date	Severity	Resolved
179270	10/02/2015 16:00	5
179260	10/02/2015 14:38	2
179258	10/02/2015 14:17	5
179255	10/02/2015 13:49	5
179254	10/02/2015 13:45	5	10/02/2015 13:55
179241	10/02/2015 11:53	5
179235	10/02/2015 11:06	1	10/02/2015 11:08
179223	10/02/2015 09:25	3	10/02/2015 09:58
179222	10/02/2015 09:13	5
179219	10/02/2015 09:05	3	10/02/2015 09:12
179206	10/02/2015 04:37	5
179200	09/02/2015 17:01	4

From the above list I want to find those records which missed the SLA

We need to consider the below condition-

1.

Severity 1 should be resolved within 3 hours

Severity 2 should be resolved within 5 hours

Severity 3 should be resolved within 3 business days

Severity 4 should be resolved within 5 business days

Severity 5 - No SLA

2.

Business timing should start from 9AM and end - 17PM

3.

Sat sunday are off day

4.

Need to follow holiday-1st may , 25th Dec

5.

If SLA fails then records should mark in RED

6.

If resolved date is null then mark it todays date.

     Please help

[#2]

The app that I attched in my replies above had that <> Hours < > Minutes. Do you still face this issue? Please attach your app .

[Anonymous]

Hi Avishek,

Again thanks for helping me.

I ahave attached application. I want output in the below format-

Number

Requested Date

Resolved Date

Severity

Actual Time taken [Based on conddition mentioned in the first email]

Actual Days(Time/8

SLA Status

[Anonymous]

I have attached my APP please help

[#5]

I have attached the modified file. Please see the column Time Elapsed in minutes.

[Anonymous]

Your application not giving proper result. I have explained in the attached doc file.