My formula for DATETIME_DIFF is not returning expected results but I can’t figure out what it’s calculating.
The first should return a difference of 1:48, the second of 0:20.
When I set the function without any specifiers, I get 4:12 and 5:40, and when I specify minutes, I get 0:04 and 0:06.
Any help would be appreciated.
Oh! you were on track with the time zone setting … I can get the correct calculation when I turn off the “use same time zone for all users” - but the weird part is, it only works if I turn it off for just one of the start/end times - if I do it for both, then we are back to the same result.
But I guess this will work for now … !