Help

NaN after calculating Duration

Topic Labels: Formulas
Solved
Jump to Solution
794 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.