Im creating a report to see how many hours it takes for the Gong-Gainsight integration to create timeline entries since the activity happened.

In the interval, I cant find Hours. Also the resultant value is not decimal either.

What is the reasoning for not having Hours, Minutes, Seconds when literally there is Milliseconds? Maybe I should submit that as an Idea.

Also I noticed, it ignores the “Time” portion and simply shows the “Day” difference. However same formula shows milliseconds in difference where it considers the time portion. Its confusing how same formula behaves differently based on Interval. This is incorrect as the interval should only affect the FRACTION of the result, not the behaviour.