<@UER9Q3SGM> does that work when DateTimes span ac...
# suiteanalyticsd
dbarnett
03/20/2020, 5:29 PM@KevinJ of Kansas does that work when DateTimes span across different days?
for that example formula, I am then getting 900 which doesnt seem to align with the 44447 difference
thanks
b
battk
03/20/2020, 6:25 PMthat formula without the multiplying should give you the difference in days
battk
03/20/2020, 6:25 PMmultiple it up to your unit of choice
d
dbarnett
03/20/2020, 6:54 PM@battk yah it just doesnt seem to be working for me in this scenario:
start : 3/20/2020 112827 pm
end : 3/21/2020 31313 am
raw formula value : 0.01041666666 (days)
b
battk
03/20/2020, 7:02 PMyour account is weird
battk
03/20/2020, 7:12 PMa more equal comparison without the multiplying business