Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

scareywa
Community profile scareywa Level 1
Job title here
Location here
5 BADGES
Level 1

Level 1

Learn more
Joined the community 30-09-2014 8:55:14 AM
Offline
Top badges earned by scareywa
Customize the badges you want to showcase on your profile
Re: Converting Report Builder time-based metrics in Excel
Avatar
Give Back
Level 1
scareywa
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

1 solution
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 1
Affirm 1
View profile
scareywa
- Adobe Analytics
Thank you! I was missing the formula =X/(1440*60)This worked perfectly! Scott

Views

402

Likes

0

Replies

0
Converting Report Builder time-based metrics in Excel
Avatar
Give Back
Level 1
scareywa
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

1 solution
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 1
Affirm 1
View profile
scareywa
- Adobe Analytics
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?

Views

837

Like

1

Replies

2
Likes given to
Likes from