It's good article and nice discussion , but it's still not clear for me why QV's Interval() function works better in this case...
Interval(TIME_SECONDS/86400, 'hh:mm:ss') as TIME_1, // result is correct
Interval(TIME_DIV_BY_86400, 'hh:mm:ss') as TIME_2, // result is wrong
Somehow QV know how to round the value correctly??
I agree with tresesco - this is the right source. Especially have a look at Robs comment: avoid using division to convert time.
See also the link above
You want to avoid transforming the data in QV - that's fine. Interval() does not transform the data, it simply formats to hh:mm:ss (or other format that you specify) - the underlying data value is unchanged.
You can prove this to yourself by entering something like this in a text box:
Num gets the underlying value...