Correct cell format for downloaded 'Average time on site' metrics data (in .csv)

[SMA23]

I am trying to download the 'Average time on site' metrics data from the workspace in .csv file.
The gets distorted, even when I select the option in excel that say "Don't convert".

Can you please suggest what should be the correct way to download or what will be the correct cell format in excel for this data.

[bjoern__koth · Accepted solution]

Hi @SMA23 
do you have some side-by-side screenshots?

For me, this looks ok

Is it that you are struggling to format it back in minutes?
In that case, this formula may be of help

=TEXT(C13/(24*60*60),"mm:ss")

[Amruthesh_AG]

Hi @SMA23 
you can try this

=INT(D13/60)&" Minutes "&MOD(B2,60)&" Seconds"
If you are expecting in this format.

Have a happy learning.

[Pankaj_Sabharwal]

Hey @SMA23 

After importing the data, you can format the column in Excel as Number with the desired number of decimal places. Also to adjust decimal places - Set the desired number of decimal places in the Decimal places section. This will display the data in a more readable format.

This should prevent data distortion and provide accurate Average time on site values in your Excel spreadsheet.

Hope this helps!