Hello all,
I am at a total loss with this one.
I have 4 x columns of data relating to bus start and end locations and times.
I am trying to schedule the buses in the most economical way.
1st bus of the day leaves Departure Point L at 04:45 this will be designated bus number 1. It arrives at point M at 05:00.
By examining columns A and B, how do I determine the next possible departure time of this bus from point M. and designate it as bus number 1. When it arrives at its destination I need to see what time is most suitable for it to leave.
In the example, I have supplied the original data and the required output.
Any help will be gratefully received.
Thanks
Pip
Bookmarks