• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Logistics Time reporting

Pra

New Member
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
 

Attachments

  • Chandoo.xlsb
    94.1 KB · Views: 3
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.
 
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/TimeDate
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
 

Attachments

  • Chandoo.xlsb
    62.1 KB · Views: 7
Back
Top