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" 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" 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