Thread: Time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Time

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