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?
