Time

[Howard]

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,

 

[David Biddulph]

=COUNTIF(D1100,"<"&TIME(0,10,0))

 

[Gary''s Student]

=COUNTIF(D,"<" & 0.00694444444)

 

[Howard]

Thank you both very much. I would never have worked it out!

 

[dlw]

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

 

[Teethless mama]

=COUNTIF(D17,"<0:10")