Find a date between two other dates to create unique values

[bom_reader]

Hello,
I am working on a project for work with a trucking transportation department where I need to find a date time number that is between two other date time numbers on another sheet. How might I use a vlookup or a match function to get a date time that is not exact? I need to match the GPS information that has no unique information save the date stamps, the scale has unique information, but it does not correspond with the GPS information. here is an example of a data set:

Truck GPS in times:
3:45 AM 6/1/2011
4:46 PM 6/2/2011
5:54 PM 6/2/2011

Truck GPS out times:
4:15 PM 6/1/2011
5:30 PM 6/2/2011
1:01 AM 6/3/2011

Scale in time:
3:48 AM 6/1/2011
4:53 PM 6/2/2011
12:01 AM 6/3/2011

I really appreciate your help with this. I am really stumped, I have no unique data in the spreadsheet except the times that are used.

 

[Trevor G]

Welcome to the forum,

Have you looked at using a Filter to search for between dates/time? You can then look to automate it if it gives you the correct results, by recording a macro and run the macro from another sheet.

 

[bom_reader]

That may work, I will let you know.