Events per hour
 

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

Events per hour
 

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
--
AP

"ER_Andy" a écrit dans le message de
...
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

Events per hour
 

Oooops:
enter the following formula into C2:C999

(example is right)
--
AP

"Ardus Petus" a écrit dans le message de
...
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
--
AP

"ER_Andy" a écrit dans le message de
...
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