times and sorting/category on all < 30 mins

[MikeR-Oz]

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

[CLR]

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

[MikeR-Oz]

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

[CLR]

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

[Dav]

If you mean the formula for less than and equal to replace < with <= in the formula

For formating the cells select the cells goto format conditional formating, select cell value is, select condition, 30 and then click on the format button to choose whatever format appeals to you!

Dav