I’ve recently started using Airtable to cut down on the number of spreadsheets that don’t talk to each other, and loving the improvements we have made so far.
One of the struggles was not being able to use a lot of features due to dates and times being in seperate columns in all our other documents, and wasn’t able to find other community posts solving this in a simple way.
After a few weeks of messing about, I finally found the DATEADD formula is the simplest:
I use a similar formula to calculate the end times.
I can now use all the lovely DATETIME formulas I’ve been excited to try out without having to do manual input, which was the goal all along.
Has anyone else had to discover this themselves? Any other workarounds people have created?