To highlight those cells over 30,.....highlight the cells, and do Format
ConditionalFormatting CellValueIs GreaterThan 30 Format choose the
format preferred ok ok............

To alter your formulas so they will accomodate both "less than" and "equal
to" 30.........

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

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

Vaya con Dios,
Chuck, CABGx3




"MikeR-Oz" wrote:

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