Split list/table according to specified time gap

[Kariba]

Hi, hope you can help. I have a table with 19 columns (and 50k + rows) which changes 3 times a week. One of the columns is times. I need to divide this where there is at least a 20 minute gap from the row above. I was thinking of identifying in a new column T eg 1, 2, 3 etc but having trouble getting it to work.

On the table below, Row 2 & 5 could be group 1, Row 3 & 8 could be group 2 etc. An added complication is there can be no more than 6 in each group.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	01/01/2024						01/01/2024 06:00													17
3	01/01/2024						01/01/2024 06:10													17
4	01/01/2024						01/01/2024 06:15													17
5	01/01/2024						01/01/2024 06:20													17
6	01/01/2024						01/01/2024 06:25													17
7	01/01/2024						01/01/2024 06:25													17
8	01/01/2024						01/01/2024 06:30													17
9	01/01/2024						01/01/2024 06:30													17
10	01/01/2024						01/01/2024 06:40													17
11	01/01/2024						01/01/2024 06:40													17
12	01/01/2024						01/01/2024 06:45													17
13	01/01/2024						01/01/2024 06:55													17
14	01/01/2024						01/01/2024 06:55													17
15	01/01/2024						01/01/2024 06:55													17
16	01/01/2024						01/01/2024 06:55													17
17	01/01/2024						01/01/2024 07:00													17
18	01/01/2024						01/01/2024 07:00													17
Sheet1

Cell Formulas
Range	Formula
T2:T18	T2	=COUNTIFS($G$1:$G$1000,">="&TIME(0,20,0))

 

[Legacy 143009]

Ok, I think I am getting it. It is more complicated than I thought. Maybe someone more clever than ne can help you.aq

 

[Kariba]

OK, no problem. Thanks for trying