Thread: Time
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Time
=COUNTIF(D1:D7,"<0:10")


"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
Reply With QuoteReply With Quote