Hi everyone

I have a dataset containing purchase data.
A B C
Date/Time Card# Amount
1 1/3/08 12:00 x1xxx 15.00
2 1/3/08 12:21 x1xxx 25.00
3 1/3/08 12:55 xxxx3 55.00

I need to calculate the count and Amount sum for each card based on a
rolling 24 hours before and after the time of purchase. For instance if a
card was use on 1/3/08 12:00 AM I need to know how many times the card was
used between 1/2/08 12:00 AM and 1/4/08 12:00 AM and the total amount
purchased. If detail to the minute is overkill then I need at least to the
hour.

Thanks for any help