[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 500"]
[TABLE="align: center, border: 0, cellpadding: 0, width: 342"]
A
[/td]B
[/td]C
[/td]D
[/td]E
[/td]F
[/td]1
[/td]Date
[/td]Batch 1
[/td]1st Time
[/td]batch 2
[/td]2nd Time
[/td]Hour
[/td]2
[/td]28/1/19
[/td]AA103
[/td]BB100
[/td]6:09am
[/td]0.75hrs
[/td]3
[/td]28/1/19
[/td]AA104
[/td]BB101
[/td]6:15am
[/td]1.23hrs
[/td]4
[/td]28/1/19
[/td]AA107
[/td]BB102
[/td]6:25am
[/td]1.18hrs
[/td]5
[/td]28/1/19
[/td]AA106
[/td]BB103
[/td]6:31am
[/td]1.43hrs
[/td]6
[/td]28/1/19
[/td]6:54am
[/td]7
[/td]28/1/19
[/td]AA102
[/td]BB106
[/td]7:09am
[/td]1.83hrs
[/td]8
[/td]28/1/19
[/td]7:29am
[/td]9
[/td]28/1/19
[/td]7:36am
[/td]10
[/td]28/1/19
[/td]AA110
[/td]BB107
[/td]7:37am
[/td]11
[/td]28/1/19
[/td]AA100
[/td]BB108
[/td]7:45am
[/td]12
[/td]28/1/19
[/td]AA101
[/td]BB109
[/td]7:51am
[/td]13
[/td]28/1/19
[/td]7:57am
[/td]14
[/td]28/1/19
[/td]AA101
[/td]BB110
[/td]7:58am
[/td]15
[/td]28/1/19
[/td]AA103
[/td]BB111
[/td]8:05am
[/td]16
[/td]28/1/19
[/td]AA107
[/td]BB112
[/td]8:19am
[/td]17
[/td]28/1/19
[/td]AA106
[/td]BB113
[/td]8:27am
[/td]18
[/td]28/1/19
[/td]AA106
[/td]BB114
[/td]8:51am
[/td]19
[/td]28/1/19
[/td]8:59am
[/td]
[/TABLE]
[/TABLE]
Basically, I want to fill the blank cell for batch1 (Column B-B6,B8,B9,B13,B19 ) from Batch 2 (Column D-D2,D3,D4,D5,D7)
base on criteria (Hour between 1st time (Col C) and 2nd time(Col E) must less than 2 Hours)
for Example 1st record , 6:54am - 6:09am = 0.75 Hours (meet the criteria), then Assign batch 2 number BB100 to Batch 1 (which is blank) B8
Subsequent for Example 2nd record , 7:29am - 6:15am = 1.23 Hours (meet the criteria), then Assign batch 2 number BB101 to Batch 1 (blank cell) B10