VBA help: Couting depending on the difference between rows

[rlan214]

let's say I have a column of time:
10:50 AM
10:53 AM
11:05 AM
11:06 AM
11:07 AM
11:11 AM
what if I want to count 1 for rows 1 and 2 since they have less than 5 min in between
and 2 for rows 3,4,5 and count 3 for row 6....
and it'll keep on counting as long as there's time

I think I can do this in excel but not sure if I can do this in an access database

Row Time Count
1 10:50 AM 1
2 10:53 AM 1
3 11:05 AM 2
4 11:06 AM 2
5 11:07 AM 2
6 11:11 AM 3

well I guess my big problem here is that I don't know how to compare the current time from the previous one

 

[Pat Hartman]

Please don't post the same question multiple times.

 

[rlan214]

Please don't post the same question multiple times.

sorry my fault