Formula for ordering trips from days

[pezalmendra]

Hello good evening,

I have attached a file in which there are 2 tables:

One in the left hand side and another in the right part of the sheet. Both of them contains the same information, the only difference is that one of them the info is ordered by trips and the other one is ordered by days

The table from the left is where I manually introduce the data and what I am looking for is a formula that orders the trips in the way I have manually done in the table from the right (red column). As you will see on the change of day the trips are repeated cause they are in between two different days.

Hope you can help me.

Thanks a lot