Skip to main content

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?

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.

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🇲🇲ss format.


Now it works.

Reply


Terms & Conditions