Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Apr 19, 2022 12:03 PM
I am using AirTable to organize my personal consulting business. I would like to sync my Google calendar with Airtable, so anytime a meeting is added I have the duration, my rate, and then the total cost. I’ve tried to sync the meetings, but it only tracks start and end time. How do I automatically calculate duration?
Solved! Go to Solution.
Apr 21, 2022 09:31 AM
Add a formula field that uses DATETIME_DIFF()
using ‘seconds’ as the time interval, and format the result as a duration.
Apr 21, 2022 09:31 AM
Add a formula field that uses DATETIME_DIFF()
using ‘seconds’ as the time interval, and format the result as a duration.
Apr 21, 2022 12:33 PM
That worked, thank you so much!