Logistics Time reporting

[Pra]

Hi

I am trying to consolidate two transport reports.
Ticket tab has list of trucks and one date/time stamp for each load and Status tab has four date/time stamps for each load (TJB,AJB,POU,TPL,IYD).
Need to get the Status time stamps into Ticket tab for each load. Need to fill column D to H in ticket tab.
Could you please advise the best formula to use.

Need to work on thousands of lines in the workbook, however reduced the rows to reduce the size of the attachment.

Thanks.

regards
Pra

 

[vletm]

Pra
You seems to need something.
Could You show few samples, even manually solved, what would be expected results?
Ps. Your Date/Time-stamps are texts.

 

[Pra]

Thanks for the response.

I have attached few samples, color coded the samples in both the tabs.

Each row in the ticket tab is a load, need to get status info from status tab for that load based on time stamp.
Basically have to retrieve the rows in status tab which has the time stamp between current load and the next load in the ticket tab.

For eg. Below are the first two rows in the ticket tab. For first row, need to retrieve all the status which have time stamp between 2021-07-01T06:11:27 and 2021-07-02T07:59:19.

Truck	Date/Time	Date
2001​	2021-07-02T06:11:27	2/07/2021​
2001​	2021-07-02T07:59:19	2/07/2021​

Hopefully I made some sense there.

Thanks.

regards
Pra

 

[vletm]

Pra
As written
Something like this ... press [ Do It ]

 

[Pra]

Thanks a lot, it works like magic!!

Appreciate your help.

regards