Events per hour

[ER_Andy]

I have a large table of arrival date_times. For each arrival event, I would
like to calculate the number of arrival events in the preceding x hour/s.

Any help much appreciated

 

[Ardus Petus]

Assuming your arrival times are in column A1:A999 and the delay (x hours) in
F1, enter the following formula into C1:C999:

=SUMPRODUCT(--(A2<(A$2:A2+$F$1)))

See example: http://cjoint.com/?dfiLqKFLBc


HTH

 

[Ardus Petus]

Oooops:
enter the following formula into C2:C999

(example is right)