A typical test run of the last routine gives this, ( using the test data from the last few posts , #158 - #163 )

_____ Workbook: Data Sheet v3.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
1
 Date Channels start time New Time
2
11.15.2017
A NEWS
20:07:00
20:21:20
3
11.15.2017
A NEWS
20:14:00
20:20:01
4
11.15.2017
A NEWS
20:21:00
20:44:24
 Duplicate
5
11.15.2017
A NEWS
20:28:00
20:58:33
6
11.15.2017
A NEWS
20:35:00
20:42:50
7
11.15.2017
A NEWS
20:42:00
20:44:24
 Duplicate
8
11.15.2017
A NEWS
20:49:00
20:58:07
9
11.15.2017
A NEWS
20:56:00
20:21:10
10
11.15.2017
A NEWS
22:49:00
22:30:03
11
11.15.2017
A NEWS
22:56:00
22:47:51
12
11.18.2017
A NEWS
23:15:00
23:57:31
13
11.18.2017
A NEWS
23:30:00
23:57:57
14
11.18.2017
A NEWS
23:45:00
23:16:35
15
11.16.2017
B NEWS
20:29:00
20:32:12
16
11.16.2017
B NEWS
20:59:00
20:18:27
17
11.18.2017
B NEWS
21:10:00
21:52:48
18
11.18.2017
B NEWS
21:20:00
21:24:26
19
11.18.2017
B NEWS
21:30:00
21:38:43
20
11.18.2017
B NEWS
21:40:00
21:53:58
21
11.18.2017
B NEWS
21:50:00
21:26:12
22
11.17.2017
C NEWS
22:13:00
22:02:01
23
11.17.2017
C NEWS
22:26:00
22:46:34
24
11.17.2017
C NEWS
22:39:00
22:42:31
25
11.17.2017
C NEWS
22:52:00
22:43:26
26
11.17.2017
D NEWS
23:13:00
23:13:00
27
28
Worksheet: OutputTestv3

File: "Data Sheet v3.xls" : https://app.box.com/s/pym52m1gslq5cynqgob8izltu6ztesim