countif time entries

[Guest]

How would I write a countif formula to count the number of time occurrences?
For example: if I wanted to know how many times stamps occurred between
10:00:00 and 10:10:00?

10:00:29
10:05:23
10:07:33
10:14:31
10:18:13
10:21:27
10:24:08
10:24:54
10:25:37
10:29:15
10:29:38
10:31:32
10:34:44
10:34:50
10:35:49
10:35:57
10:43:25
10:50:25
10:51:22
10:55:53
10:56:09
10:56:30

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100>=TIME(10,0,0)),--(A1:A100<=TIME(10,10,0)))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Alan]

=SUMPRODUCT((A5:A25>=TIME(10,0,0))*(A5:A25<=TIME(10,10,0)))