Help

Re: Getting false results to DATETIME_DIFF formula

Solved
Jump to Solution
471 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Andonisz_Haroni
4 - Data Explorer
4 - Data Explorer

Hi,

I try to calculate the time duration between two date fields with DATETIME_DIFF formula, but doesn’t work at all. It shows totally false results.

Here it is:

airtable1

This is the formula I use:

airtable2

This is the formatting for duration:

airtable3

Any idea what I should do?

1 Solution

Accepted Solutions
Andonisz_Haroni
4 - Data Explorer
4 - Data Explorer

Hi there,

Thanks for your responses!

The solutions was.

One time field was in GMT while the other wasn’t. So I turned off this setting on both.

Furthermore the formula has been set to Duration and h:mm:ss format.

Now it works.

See Solution in Thread

3 Replies 3

Hi @Andonisz_Haronisz - it is because you have the result as a duration when it should be an integer. From the formula docs:

Note : The DATETIME_DIFF() formula will return whole integers for any unit specifier.

Try using the unit specifier ‘seconds’ instead of ‘minutes’ in your formula.

Andonisz_Haroni
4 - Data Explorer
4 - Data Explorer

Hi there,

Thanks for your responses!

The solutions was.

One time field was in GMT while the other wasn’t. So I turned off this setting on both.

Furthermore the formula has been set to Duration and h:mm:ss format.

Now it works.