Monday, August 10, 2015

How to change "Average Time on Page" into as written on google analytics?

Google analytic report that has been download into excel on Avg Session Duration somehow change into some amount that is different from Google Analytic online.

Here is the Excel Function that you need to put on the cells  = x/86400
On the Format cells, you need to change into " custom " and choose "mm:ss"

Here is on detail :



This is how to make it as it seen on google analytic:
- On the other empty column , click function , then type =A1/(60*60*24)

- Drag the number into row that need to be changed.
- Change "format cells" into custom, pick hh:mm:ss