View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smcmoran smcmoran is offline
external usenet poster
 
Posts: 10
Default Countif in a time range

I have a list of 14,000+(DTTM) dates and times from a month, (i.e.9/1/2008
9:20:00 AM). I need to count how many rows have a time stamp between 08:00
and 17:00. I copied the column over one and formated it down to a 24 hour
time format. Is there a way to trim this column or write a formula that only
counts thte time?

Thanks
Scott