Hi

First you need to split and times using 'Text To Columns' with 'space'
as delimitter.

Then use use this formula to calculate occurences in range:

=SUMPRODUCT(--(A1:A3=DATEVALUE("08-09-2009")),--(B1:B3=TIMEVALUE
("08:00")),--(B1:B3<TIMEVALUE("10:00")))

Regards,
Per

On 8 Sep., 22:58, dlowrey wrote:
Good afternoon

Col A has a list of dates and times. *The data looks like this:
08/09/09 08:12
08/09/09 09:15
08/10/09 07:59.. etc.

Each date/time represents one transaction.
We need to count the number of transactions occurring on a each day between
two times. *For example, on 8/09/09 between 8:00 and 9:59 the answer would be
2.

Can you give me some ideas about how to approach this problem? *We don't
want to script this, but will use a separate cell on a sheet for each date
and time range.

Thanks in advance for your help.
-DL