I am constructing a bus timetable.
I am starting with a base time of 9am (Cell B2), with irregular intervals:
B C D 2 09:00 10:30 12:00 3 09:05 4 09:12 5 10:14 6 10:20
When the bus comes back to the depot it will depart again at 10:30 (Cell C2), and 12:00 (Cell D2) the third time.
Is there a formula so that the time intervals given in rows B2:B6, can be mimicked in rows C3:C6, and D3:D6?
I can PM image if needed!