Skip to main content

I have a date time difference formula formatted to decimal with 2 places but not returning any values less that one. My formula is as follows: 

DATETIME_DIFF({End Time},{Start Time},'hours')

What am I missing? If I recall correctly this should be able to return hours less than 1 (e.g. 0.5 for half an hour difference)

Hey :)

Probably not the most elegant solution, but this formula works for me:

ROUND(DATETIME_DIFF({End Time}, {Start Time}, 'minutes') / 60, 2) & ""

Hey ​@Cody_Winchester,

Please see screenshots below. 
 



 


Formatting for formula:

 



Hope this helps!

Mike, Consultant @ Automatic Nation

Thanks ​@Mike_AutomaticN, this is what I ended up doing. I had thought that the functions in the formula had that divisible already accounted for (i.e. If set to ‘hours’ technically that would mean half an hour would be 0.5 ‘hours”). Thanks for confirming.

Oh yes ​@Cody_Winchester, that is what one would asume lol!
Glad to hear that is solved now.

Mike, Consultant @ Automatic Nation

Terms & Conditions