Appreciate that CLR- simple and effective. Is there also a way of
Highlighting those numbers / cells that are over the 30 minutes and whats the
formulas for == to and < than the 30 mins to be captured?

Mike
"CLR" wrote:

With your range of values in column A,
This will tell you how many are less than 30......

=COUNTIF(A:A,"<30")

This will tell you that percentage of the total......

=COUNTIF(A:A,"<30")/COUNT(A:A) format as Percent

Vaya con Dios,
Chuck, CABGx3



"MikeR-Oz" wrote:

I have a range of times from 11 minutes to 180 mins. I would like to be able
to know how many of these times are less than 30 minutes and also that
reflected as a % of the total.
How do I do This?
Mike