Hi Excel Gurus,

I am trying to workout a formula to find the number of instances between a time range and the details of instances. My excel sheet looks like.,

ID Change Start Date/Time Change End Date/Time
823067 9/13/2008 10:00 9/15/2008 7:00
835924 9/14/2008 7:00 9/15/2008 7:00
887554 11/21/2008 15:00 11/21/2008 17:00
897233 9/18/2008 10:00 9/18/2008 15:00

I would like to find out.,

- Number(count) of instances occuring between 06:00am - 08:00am(irrespective of the days)
- Details(ID) of instances aswell..if its easily achieveable.

Thanks in advance.
V