I am having difficulty figuring out the formula needed to return a time value that is between 6 and 15 mins higher than the look up value.
1. I have a train arriving at 5:12
2. I need to look at a range of times to find the next closest time to 5:12 (between 6 and 15 mins)
3. In this example that time would be 5:17. I then need to add in the train for wynyard that matches the 5:17 st marys train.
4. In this example it would be 6:18
I have attached a file that hopefully explains it a bit better than above. I have tried an index match formula based on matching St Marys with St Marys, however I can't work out how to get the next available time based on my rule of 6 and 15 mins.
Any help on this will be greatly appreciated!