Count records b/w time range

[sunilkeswani]

I have a sheet which has data with date & time fields like this

19/10/2005 10:10
19/10/2005 11:30
19/10/2005 12:12
19/10/2005 12:15
19/10/2005 10:12


How do I make a formula to pull out count between each half hour slot?

like:

10:00 - 10:30 =2
10:30 - 11:00 =0
11:00 - 11:30 =1
11:30 - 12:00 =0
12:00 - 12:30 =2

Please help.

Cheers!
Sunny

 

[Bob Phillips]

=sumproduct(--(B1:B100>--"10:00:00"),--(B1:B100<=--"10:30:00"))

--

HTH

RP
(remove nothere from the email address if mailing direct)