Google Analytics Time On Site in Excel Format

For example:
Average Time on Site is 00:05:58
but it comes into Excel as 357.812313003452
To convert it properly, use the formula =A2/60/24/60
Don’t forget to format the cell format as “hh:mm:ss”

1 thought on “Google Analytics Time On Site in Excel Format

Leave a Comment