The formula is indicated on the screenshot. How to get Duration value, not a NaN?
Solved
NaN after calculating Duration
Best answer by kuovonne
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.
+29Welcome 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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.