I have an Excel question, in the example below I have a very long list of dates times where I added a column to calculate gaps, and tagged rows where the gap were less than 15 minutes to try to determine a possible consecutive activity. Do you have any idea how to get the groups of tagged rows to calculate a time like latest minus earliest for each tagged group?
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
VisitCount | LastAccessed | Last Access Date | Last Access Time | Gap (hms) | Tag (+) if gap less than 15 min |
2 | 5/29/18 8:26 AM | 05/29/18 | 8:26:58 AM | ||
1 | 5/29/18 12:07 PM | 05/29/18 | 12:07:12 PM | 3:40:14 | |
1 | 5/29/18 12:10 PM | 05/29/18 | 12:10:35 PM | 0:03:23 | + |
1 | 5/29/18 12:14 PM | 05/29/18 | 12:14:46 PM | 0:04:11 | + |
1 | 5/29/18 12:15 PM | 05/29/18 | 12:15:11 PM | 0:00:25 | + |
1 | 5/29/18 12:20 PM | 05/29/18 | 12:20:28 PM | 0:05:17 | + |
1 | 5/29/18 12:22 PM | 05/29/18 | 12:22:51 PM | 0:02:23 | + |
1 | 5/29/18 12:23 PM | 05/29/18 | 12:23:10 PM | 0:00:19 | + |
1 | 5/29/18 12:25 PM | 05/29/18 | 12:25:33 PM | 0:02:23 | + |
1 | 5/29/18 12:26 PM | 05/29/18 | 12:26:13 PM | 0:00:40 | + |
1 | 5/29/18 12:31 PM | 05/29/18 | 12:31:48 PM | 0:05:35 | + |
1 | 5/29/18 4:02 PM | 05/29/18 | 4:02:35 PM | 3:30:47 | |
1 | 5/29/18 4:02 PM | 05/29/18 | 4:02:35 PM | 0:00:00 | + |
1 | 5/29/18 4:02 PM | 05/29/18 | 4:02:35 PM | 0:00:00 | + |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>