Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

NaN after calculating Duration

Topic Labels: Formulas
Solved
Jump to Solution
316 1
cancel
Showing results for 
Search instead for 
Did you mean: 

The formula is indicated on the screenshot. How to get Duration value, not a NaN?

Screen Shot 2020-09-17 at 4.04.46 PM Screen Shot 2020-09-17 at 4.04.36 PM Screen Shot 2020-09-17 at 4.04.29 PM Screen Shot 2020-09-17 at 4.03.50 PM

1 Solution

Accepted Solutions

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.

See Solution in Thread

1 Reply 1

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.