percentage fixed in time

**wlln001** · 12-10-2008, 10:39 AM

Hi

I have a Stats spreadsheet which contains a column of figures which represent the time it took to fix a fault... I need to calculate how many, as a %, where fixed within our SLA... example: 90% were fixed in 4hrs..

can somebody work out a formular to do this..

Cheers

**martindwilson** · 12-10-2008, 11:36 AM

depends on layout and formats but something like
=COUNTIF(A1:A20,"<=4")/COUNT(A1:A20) formated as percentage

**ChrisMattock** · 12-10-2008, 11:40 AM

If the range of times was in column A, and your SLA was in cell B1 then this would work.

=COUNTIF(A1:A5,"<"&$B$1)/COUNT(A1:A5)

EDIT Ah, damn it, beaten to it.