IF + DATETIME_DIFF Formula Help! 🙏🏼

[Andonisz_Haroni]

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:

This is the formula I use:

This is the formatting for duration:

Any idea what I should do?

[JonathanBowen]

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.

[kuovonne]

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

[Andonisz_Haroni · Accepted solution]

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.