
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2020 06:09 AM
The formula is indicated on the screenshot. How to get Duration value, not a NaN?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2020 07:58 AM
Welcome to the Airtable community!
Math with dates can get a little tricky. Sometimes you need to use a function instead of a simple operator.
DATETIME_DIFF({Starttime}, {Requestdate}, 'seconds')
It is documented in the formula field reference.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 17, 2020 07:58 AM
Welcome to the Airtable community!
Math with dates can get a little tricky. Sometimes you need to use a function instead of a simple operator.
DATETIME_DIFF({Starttime}, {Requestdate}, 'seconds')
It is documented in the formula field reference.
