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