Issue exporting Avg. Time On Site into a spreadsheet

Question

When I export a .cvs from Adobe Analytics, the Average Time On Site columns have a strange number in those cells instead of an actual time reference from the online project. Should I be able to export actual time references for Average Time On Site? Is there a reason why this is happening? Is there a way to translate the strange exported numbers into a valid time format?

So far, my only work-around is to delete these numbers and manually type them in from looking at the Adobe Analytics project (because also I cannot copy and paste figures from Adobe Analytics either).

I also took screenshots of each section and used Apple Photos or Preview to copy the text for each column I needed to add the figures for.

There has to be a better way. I searched and found nothing online about this. I searched the forum here and found nothing. I'm really hoping that I'm just missing something here cause my eyes are bleeding from doing this last night.

Jennifer_Dungan · Accepted Answer

I believe that the values may be exported as seconds.. if you are looking at the data in Excel, you can convert using this formula:

=[cell]/(60*60*24)

Then formatting that result with a custom format

m:ss

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded