Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

NaN after calculating Duration

Topic Labels: Formulas
Solved
Jump to Solution
1190 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Anastasiya_Dziu
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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.