Formula
Say your list of times is in Column A,
And the "less then" criteria (your "x") is in C1,
Then try this:
=COUNTIF(A:A,"<"&C1)/COUNT(A:A)
Format the cell you enter this formula in as a Percent.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Slinky" wrote in message
...
We are trying to get a formula to use for reponse times for our Fire
Rescue.
For a list of response times, we are trying to get a formula to tell us
what
percent of the time did we respond less than "x" amount of time. (i.e. 90%
of
the time we responded in less than 4 minutes if the times were 4, 3, 3, 3,
3,
3, 3, 3, 3, 3, 3) Thank you for any help I can get!!!
|