I have a table similar to the one below. Column A shows the start time and column B the end time. In cells C1:C7 I have a list of calculated elapsed times.
I need to count the times that are between column A:B. There are many hundreds of rows and this is only a small sample.
Despite trying to use the CountIf function I cannot resolve what would seem to be a simple problem so any help would be appreciated.
I need to count the times that are between column A:B. There are many hundreds of rows and this is only a small sample.
Despite trying to use the CountIf function I cannot resolve what would seem to be a simple problem so any help would be appreciated.
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 01:33 | |||||
2 | 00:10 | |||||
3 | 02:33 | |||||
4 | ||||||
5 | ||||||
6 | ||||||
7 | ||||||
8 | ResultTable | |||||
9 | 00:01 | 01:00 | 1 | |||
10 | 01:01 | 02:00 | 1 | |||
11 | 02:01 | 03:00 | 1 | |||
12 | 03:01 | 04:00 | ||||
Sheet1 |