Hello. I’m glad to have found this thread as I am working on a very similar project and I’m hoping you can offer your insights, and formulas!
I’m new here, so please forgive the non-airtable language.
What I need to create is an itinerary for a bus tour which all happens on the same day and stops at different locations. I would love to create a table which sorta looks like this and makes these calculations:
I’m thinking 2 columns:
Description | time or duration
Departure time | 8AM
Travel time to location A | 20 minutes
Arrival time at location A | adds 20 minutes to 8AM to display 8:20AM
Visiting time at location A | 45 minutes
Departure time | adds the visiting time to the arrival time to display 9:05AM
The tour travels to 5 locations, so I’d repeat that sequence 4 more times. Departure and Arrival times would keep updating as the day progresses.
And we also want a total time traveled at the bottom somewhere which would add all the travel and visiting times up!
So my questions are:
What’s a good way to set this table up?
What type of fields do I use?
What are the formulas I need in the Departure and Arrival times fields?
Once I have one airtable, I plan to duplicate it, so that other tour directors can use my template to plan their day tours!
Thanks in advance and I look forward to hearing from you.