How to set up Time table?

sorry, Im new to airtable. I try to set up time calculator formula in AT and couldn’t figure out.
For example . in LA is 6pm as basecamp, and list 6 different cities and calculate their location time against LA time. that’s that event starting time, and then calculate their presentation time which is 1.5 hour into the event from the starting time.

also if any of you know the video specifically help me to put together formula, please advise.

Hi Ari,

First create a datetime formula field with the start of your event. Then create a new formula field for each new timezone. In that formula field use the Dateadd formula. Here’s an example:

For videos, check out the formula & datefield type lessons here

1 Like