Corresponding Sheet1 for the data Sheet2 of the last 3 posts:

_____ Workbook: Data Sheet v3.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
1
 Date Channels start time New Time
2
11.15.2017
A NEWS
20:07:00
3
11.15.2017
A NEWS
20:14:00
4
11.15.2017
A NEWS
20:21:00
5
11.15.2017
A NEWS
20:28:00
6
11.15.2017
A NEWS
20:35:00
7
11.15.2017
A NEWS
20:42:00
8
11.15.2017
A NEWS
20:49:00
9
11.15.2017
A NEWS
20:56:00
10
11.15.2017
A NEWS
22:49:00
11
11.15.2017
A NEWS
22:56:00
12
11.18.2017
A NEWS
23:15:00
13
11.18.2017
A NEWS
23:30:00
14
11.18.2017
A NEWS
23:45:00
15
11.16.2017
B NEWS
20:29:00
16
11.16.2017
B NEWS
20:59:00
17
11.18.2017
B NEWS
21:10:00
18
11.18.2017
B NEWS
21:20:00
19
11.18.2017
B NEWS
21:30:00
20
11.18.2017
B NEWS
21:40:00
21
11.18.2017
B NEWS
21:50:00
22
11.17.2017
C NEWS
22:13:00
23
11.17.2017
C NEWS
22:26:00
24
11.17.2017
C NEWS
22:39:00
25
11.17.2017
C NEWS
22:52:00
26
11.17.2017
D NEWS
23:13:00
27
28
Worksheet: Sheet1v3