Unit of time for average time on page?

[Jes Constantine]

Sorry if this is a duplicate question, I have read some topics about US number formatting... when I use average time on page as a metric, what is the unit of time returned?  The Dimensions and Metrics explorer just says Time.  Google Sheets defaults to scientific notation.  It does have a number format 'duration' but that doesn't look right, neither does decimal... what do people use to show H:M:S?  Or even just Seconds? 

Thanks!

[Philip Walton]

The time unit should be seconds. What do your results look like? What locale is your spreadsheet set to?

On Thu, Jul 2, 2015 at 1:00 PM, Jes Constantine <jescons...@gmail.com> wrote:

Sorry if this is a duplicate question, I have read some topics about US number formatting... when I use average time on page as a metric, what is the unit of time returned?  The Dimensions and Metrics explorer just says Time.  Google Sheets defaults to scientific notation.  It does have a number format 'duration' but that doesn't look right, neither does decimal... what do people use to show H:M:S?  Or even just Seconds? 

Thanks!

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/4c3d73d3-3fac-477b-89a3-40c0cedfd2b0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[ant...@speakplus.fr]

That indeed should be seconds. As a solution to show the H:M:S format, I've divided metrics by /60/60/24 (ex: =B2/60/60/24) and then set the number format 'duration' to show a proper result. Even if it is a bit long, this actually works. 

However, I do have a problem about the unit of time. Indeed, some of my metrics appear as dates when I use average time on page / average session duration in my SpreadSheet. And even with the trick I've introduced above, it does not show the actual right metrics compare to my Analytic's ones.

Do you have an explanation by chance?

Thanks!

Le lundi 6 juillet 2015 18:26:53 UTC+2, Philip Walton a écrit :

The time unit should be seconds. What do your results look like? What locale is your spreadsheet set to?

On Thu, Jul 2, 2015 at 1:00 PM, Jes Constantine <jescons...@gmail.com> wrote:

Sorry if this is a duplicate question, I have read some topics about US number formatting... when I use average time on page as a metric, what is the unit of time returned?  The Dimensions and Metrics explorer just says Time.  Google Sheets defaults to scientific notation.  It does have a number format 'duration' but that doesn't look right, neither does decimal... what do people use to show H:M:S?  Or even just Seconds? 

Thanks!

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[iaudie...@gmail.com]

I have the same problem.
GA show 00:01:38 and add on returns 25517, and when I divide it with or 86400 and format cell as duration, I get 7:05:17.

Any advice?