NaN after calculating Duration

Anastasiya_Dziu · ‎Sep 17, 2020

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.03.50 PM

kuovonne · ‎Sep 17, 2020

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.

kuovonne · ‎Sep 17, 2020

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.

Automatic duration calculator