Help

How to set up Time table?

686 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ari_horie
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
Aron_Korenblit
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Image 2019-07-06 at 10.06.41.png

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