excel extra data and match with different row

[phooirv]

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[TABLE="width: 642"]
<tbody>[TR]
[TD="width: 97"]

Date​

[/TD]
[TD="width: 69"]

Batch 1​

[/TD]
[TD="width: 76"] 1st time
[/TD]
[TD="width: 76"] Batch 2
[/TD]
[TD="width: 91"] 2nd Time
[/TD]
[TD="width: 80"] Hour
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA103​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB100​

[/TD]
[TD="width: 91, bgcolor: transparent"]

6:09 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"] 0.75hrs
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA104​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB101​

[/TD]
[TD="width: 91, bgcolor: transparent"]

6:15 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"] 1.23 hrs
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA107​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB102​

[/TD]
[TD="width: 91, bgcolor: transparent"]

6:25 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"] 1.18 hrs
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA106​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB103​

[/TD]
[TD="width: 91, bgcolor: transparent"]

6:31 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"] 1.43hrs
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA106​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB104​

[/TD]
[TD="width: 91, bgcolor: transparent"]

6:46 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"] 0.13hrs
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA105​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB105​

[/TD]
[TD="width: 91, bgcolor: transparent"]

6:52 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"] 0.03hrs
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

BB100​

[/TD]
[TD="width: 76"]

6:54 AM​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA102​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB106​

[/TD]
[TD="width: 91, bgcolor: transparent"]

7:09 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"] 1.83 hrs
[/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

BB101​

[/TD]
[TD="width: 76"]

7:29 AM​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

​

[/TD]
[TD="width: 76"]

7:36 AM​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA110​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB107​

[/TD]
[TD="width: 91, bgcolor: transparent"]

7:37 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA100​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB108​

[/TD]
[TD="width: 91, bgcolor: transparent"]

7:45 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA101​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB109​

[/TD]
[TD="width: 91, bgcolor: transparent"]

7:51 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

​

[/TD]
[TD="width: 76"]

7:57 AM​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA101​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB110​

[/TD]
[TD="width: 91, bgcolor: transparent"]

7:58 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA103​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB111​

[/TD]
[TD="width: 91, bgcolor: transparent"]

8:05 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160"]
[/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA107​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB112​

[/TD]
[TD="width: 91, bgcolor: transparent"]

8:19 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA106​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB113​

[/TD]
[TD="width: 91, bgcolor: transparent"]

8:27 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

AA106​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76"]

BB114​

[/TD]
[TD="width: 91, bgcolor: transparent"]

8:51 AM​

[/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97"]

28/01/2019​

[/TD]
[TD="width: 69"]

​

[/TD]
[TD="width: 76"]

8:59 AM​

[/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 97, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 2, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 869, bgcolor: transparent, colspan: 10"] Base on Column E (2nd Time, will search for Column B (batch 1) which is Blank Only, if the Hour is different less than 2.0 Hours (1st time - 2nd Time)
[/TD]
[/TR]
[TR]
[TD="width: 318, bgcolor: transparent, colspan: 4"] Then allocate Batch 2 Number to Batch 1 Number
[/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 97, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 854, bgcolor: transparent, colspan: 9"] for Example 1st record , 6:54am - 6:09am = 0.75 Hours (meet the criteria), then Assign batch 2 number BB100 to Batch 1 (blank cell) B8 in red
[/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 97, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 869, bgcolor: transparent, colspan: 10"] 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 in red
[/TD]
[/TR]
[TR]
[TD="width: 97, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 854, bgcolor: transparent, colspan: 9"] As for Row 6 and 5 , no record found to allocate as all batch 1 record is fully allocated (1st come 1 serve base on 2nd time )
[/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 97, bgcolor: transparent"][/TD]
[TD="width: 69, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 91, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 139, bgcolor: transparent"][/TD]
[TD="width: 160, bgcolor: transparent"][/TD]
[TD="width: 66, bgcolor: transparent"][/TD]
[TD="width: 15, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

Your post is very confusing, at least to me.
What exactly do you need help with ?

 

[phooirv]

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Date
[/TD]
[TD]Batch 1
[/TD]
[TD]1st Time
[/TD]
[TD]batch 2
[/TD]
[TD]2nd Time
[/TD]
[TD]Hour
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]28/1/19
[/TD]
[TD]AA103
[/TD]
[TD][/TD]
[TD]BB100
[/TD]
[TD]6:09am
[/TD]
[TD]0.75hrs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]28/1/19
[/TD]
[TD]AA104
[/TD]
[TD][/TD]
[TD]BB101
[/TD]
[TD]6:15am
[/TD]
[TD]1.23hrs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]28/1/19
[/TD]
[TD]AA107
[/TD]
[TD][/TD]
[TD]BB102
[/TD]
[TD]6:25am
[/TD]
[TD]1.18hrs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]28/1/19
[/TD]
[TD]AA106
[/TD]
[TD][/TD]
[TD]BB103
[/TD]
[TD]6:31am
[/TD]
[TD]1.43hrs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]28/1/19
[/TD]
[TD][/TD]
[TD]6:54am
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]28/1/19
[/TD]
[TD]AA102
[/TD]
[TD][/TD]
[TD]BB106
[/TD]
[TD]7:09am
[/TD]
[TD]1.83hrs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]28/1/19
[/TD]
[TD][/TD]
[TD]7:29am
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]28/1/19
[/TD]
[TD][/TD]
[TD]7:36am
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]28/1/19
[/TD]
[TD]AA110
[/TD]
[TD][/TD]
[TD]BB107
[/TD]
[TD]7:37am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]28/1/19
[/TD]
[TD]AA100
[/TD]
[TD][/TD]
[TD]BB108
[/TD]
[TD]7:45am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]28/1/19
[/TD]
[TD]AA101
[/TD]
[TD][/TD]
[TD]BB109
[/TD]
[TD]7:51am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD]28/1/19
[/TD]
[TD][/TD]
[TD]7:57am
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD]28/1/19
[/TD]
[TD]AA101
[/TD]
[TD][/TD]
[TD]BB110
[/TD]
[TD]7:58am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]28/1/19
[/TD]
[TD]AA103
[/TD]
[TD][/TD]
[TD]BB111
[/TD]
[TD]8:05am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16
[/TD]
[TD]28/1/19
[/TD]
[TD]AA107
[/TD]
[TD][/TD]
[TD]BB112
[/TD]
[TD]8:19am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17
[/TD]
[TD]28/1/19
[/TD]
[TD]AA106
[/TD]
[TD][/TD]
[TD]BB113
[/TD]
[TD]8:27am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18
[/TD]
[TD]28/1/19
[/TD]
[TD]AA106
[/TD]
[TD][/TD]
[TD]BB114
[/TD]
[TD]8:51am
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19
[/TD]
[TD]28/1/19
[/TD]
[TD][/TD]
[TD]8:59am
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]


Basically, I want to fill the blank cell for batch1 (Column B-B6,B8,B9,B13,B19 which is hightlighed in yellow) 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