Formula

[jalenben1]

I am given the following:

For the SLA

4 Hours = 240 minutes
12 Hours = 720 minutes
18 Hours = 1080 minutes

How would I write a formula in Excel if I have the outage minutes of 139, 5388, 3, 5809, 1016, 10, 1754, 225, 348, 123, 361, 62, 28 and 363.

I am trying to determine the SLA above based off of the outage minutes.

 

[jalenben1]

I am not sure if I was clear enough earlier:

I am given the following:

For the SLA

4 Hours = 240 minutes
12 Hours = 720 minutes
18 Hours = 1080 minutes

How would I write a formula in Excel if I have the outage minutes of 139, 5388, 3, 5809, 1016, 10, 1754, 225, 348, 123, 361, 62, 28 and 363.

I am trying to determine the SLA above based off of the outage minutes.

I just got confirmation that if an outage minutes is equal or less than 240 minutes then the SLA of 4 hours was met but if it had exceeded 240 minutes then it wwould may have fallen into the SLA of the next on ewhich is 720 minuts which is 12 hours.

Does that make more sense in how to calculate the formula?

 

[SkipVought]

Hi,

Are you talkin Special Libraries Association, Science Leadership Academy, Symbionese Liberation Army???

Or maybe Service Level Agreement?

Please understand that very often we can;t tell what's in your head. Certainly it is difficult to know exactly WHAT statistic you have in mind here.

I am trying to determine the SLA above based off of the outage minutes.

Well if YOU don't know what the SLA is, I sure don't. However, if your question is that your are trying to report the outage minutes against the SLA, that's a question that you have not asked, but it is implied in your next paragraph.

So you want a COUNT based on incident if the outage meets or exceeds the SLA level?

1. Put your SLA requirements in a table like...
[tt]
SLA_Table SLA_Nomen
0 Meets
240 Exceed 1
720 Exceed 2
1080 Exceed 3
[/tt]
2. Name your ranges base on the table headings

3. The formula, assuming that your outage value is in A2...
[tt]
A2: =INDEX(SLA_Nomen,MATCH(A2,SLA_Table,1),1)
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jalenben1]

Skip:

I am understanding this correctly I have the following:
Column A Column B Column C
Outage Minutes SLA Nomen SLA
139 Met 4 Hours
5883 Exceeds 18 Hours
5809 Met 18 Hours
1016 Met 12 Hours
10 Met 4 Hours
1754 Exceeds 12 Hours

Based of that above I am trying to deterimine the SLA from below
4 Hours = 240 minutes
12 Hours = 720 minutes
18 Hours = 1080 minutes
to go in Cloumn C

 

[jalenben1]

Skip:

Is that what you mean?

 

[SkipVought]

Then put whatever you want to return in the SLA_Nomen column.

Keep in mind, this solution has

1) a SLA Table with 2 columns and 4 rows and

2) your outage list, that you want to annotate with values returned from the SLA Table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}