Prev: WordWrap a TextBox on a UserForm
Next: How do I find duplicate entries in a column in an Excel worksh
From: Howard on 22 Apr 2010 16:33
I have time (mm:ss) in Column D. How do I count the number of times that the
time is less than 10 minutes.

Thanks,
--
Howard
From: "David Biddulph" groups [at] on 22 Apr 2010 16:51
=COUNTIF(D1:D100,"<"&TIME(0,10,0))
--
David Biddulph


"Howard" <DFM(a)discussions.microsoft.com> wrote in message
news:53C4F42F-C181-4BE0-B93C-590F0E5F1627(a)microsoft.com...
> I have time (mm:ss) in Column D. How do I count the number of times that
> the
> time is less than 10 minutes.
>
> Thanks,
> --
> Howard


From: Gary''s Student on 22 Apr 2010 17:29
=COUNTIF(D:D,"<" & 0.00694444444)

--
Gary''s Student - gsnu201001
From: Howard on 22 Apr 2010 17:36
Thank you both very much. I would never have worked it out!
--
Howard


"David Biddulph" wrote:

> =COUNTIF(D1:D100,"<"&TIME(0,10,0))
> --
> David Biddulph
>
>
> "Howard" <DFM(a)discussions.microsoft.com> wrote in message
> news:53C4F42F-C181-4BE0-B93C-590F0E5F1627(a)microsoft.com...
> > I have time (mm:ss) in Column D. How do I count the number of times that
> > the
> > time is less than 10 minutes.
> >
> > Thanks,
> > --
> > Howard
>
>
> .
>
From: dlw on 22 Apr 2010 17:36
make a helper column that just shows the seconds , =second(D1) and copy down,
and then =countif(E1:E10,">10") where E is the column showing the seconds

"Howard" wrote:

> I have time (mm:ss) in Column D. How do I count the number of times that the
> time is less than 10 minutes.
>
> Thanks,
> --
> Howard
 |  Next  |  Last
Pages: 1 2
Prev: WordWrap a TextBox on a UserForm
Next: How do I find duplicate entries in a column in an Excel worksh