I should have explained further:

First I need to compare the time in Col E to the time in Col F for each record (each name in Col F is it's own record) and then find the times that are the closest match. I then need to keep that record and delete the others.

Second, if the closest time match has more than one record (as shown in sample), I need to keep the record that has the lowest value in Col G.

I am experimenting with comparing dates but I am having trouble with including records also.

Can anyone please assist with this?