Forum Discussion
BBojana
Sep 04, 2022Copper Contributor
Please help
Hello! I urgently need some help with Excel, because I´m totally new in all of this and for these two problems that I have I simply can´t find an adequate answer online. I need to make a simple ta...
Riny_van_Eekelen
Sep 04, 2022Platinum Contributor
BBojana Best to use a structured Excel table. It will automatically expand as you add more stops. Format the Time columns with a custom format hh:mm
The attached file contains such a table. The formula in the Departure column takes the time from the Arrival column (if it is not blank) and add 3/1440 to it. Note that Excel calculates with parts of a 24 hour day. Thus, 3 minutes = 3/1440 of one day.