JamieGoetz
New member
- Joined
- Nov 21, 2014
- Messages
- 5
- Reaction score
- 0
- Points
- 0
Hello,
I have a set or criteria that requires 2 or more separate one hour periods to have >=2 cars. Keep in mind, it doesn't have to be whole hours. Each 15 min starts a new 60 min period. As shown below, at 12:00 1 car returns No. 12:15 returns Yes. 12:30 and 12:45 have 2 or more but don't count anymore because they occupy the same 60min as the first instance.
I am trying to come up with a formula that finds the first instance of >=2 in the cars column. It then must skip the next three 15 min intervals and continue the search.
I have a set or criteria that requires 2 or more separate one hour periods to have >=2 cars. Keep in mind, it doesn't have to be whole hours. Each 15 min starts a new 60 min period. As shown below, at 12:00 1 car returns No. 12:15 returns Yes. 12:30 and 12:45 have 2 or more but don't count anymore because they occupy the same 60min as the first instance.
I am trying to come up with a formula that finds the first instance of >=2 in the cars column. It then must skip the next three 15 min intervals and continue the search.
A | B | C | D | E |
1 | Time | Cars | ||
2 | 12:00 | 1 | No | |
3 | 12:15 | 2 | Yes | |
4 | 12:30 | 2 | N/A | |
5 | 12:45 | 3 | N/A | |
6 | 13:00 | 1 | N/a | |
7 | 13:15 | 1 | No | |
8 | 13:30 | 2 | Yes | |
9 | 13:45 | 1 | N/A | |
10 | 14:00 | 2 | N/A |