Hi,

Try this. C13 and C14 hold 01:00 and 16:00 respectively.

=SUMPRODUCT((D4:D11=C13)*(D4:D11<=C14))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tomster27" wrote in message
...
I have a list of times (part of which is included below). I want to be
able
to count them if they fall between the times of 01:00 and 16:00 and ignore
them if they fall outside those times. I have tried COUNTIF but have got
very
badly stuck. I would be very grateful for any help

20:26
10:15
23:24
1:45
15:23
15:57
5:01
14:18