https://forums.adobe.com/community/business_catalyst/reporting_and_analytics?view=discussions Most recent forum messages en Tue, 30 Sep 2014 15:59:41 GMT Jive Engage 7.0.0.1 (http://jivesoftware.com/products/) 2014-09-30T15:59:41Z en https://forums.adobe.com/message/6777613?tstart=0#6777613 <!-- [DocumentBodyStart:d212f2db-605e-46f2-b741-f748f466db58] --><div class="jive-rendered-content"><p>I am having trouble with my time-based metrics (avg. time spent) when I pull it in using Report Builder. Excel seems to take it out of the HH:MM:SS format and makes it a number. So when I run a report with the Avg Time Spent metric in the Adobe Interface, the correct format is displayed but when I run it with Report Builder a random number is displayed. I can't seem to convert it to the correct time. Can anyone help? </p></div><!-- [DocumentBodyEnd:d212f2db-605e-46f2-b741-f748f466db58] --><img src='/beacon?t=1415883444950' /> Tue, 30 Sep 2014 15:59:41 GMT forums_noreply@adobe.com https://forums.adobe.com/message/6777613?tstart=0#6777613 2014-09-30T15:59:41Z 1 month 2 weeks ago 0