ga:avgTimeOnPage in a strange format

[Thiago Araújo]

Does anyone have any idea how to convert this ga:avgTimeOnPage in seconds?! I've tried to divide by 86400 (60*60*24), but it does not work. :(

Thanks!

[Philip Walton]

I think this is a number formatting issue. The solution has been discussed in this group before, just do a search for "format":

https://groups.google.com/forum/#!searchin/google-analytics-spreadsheet-add-on/format%7Csort:relevance

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/b056b4e2-2a01-4645-bfdf-a367e9b9ee84%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Thiago Araújo]

HI, Philip. Thanks for answering, but I've already read that solutions. What happens here is that the spreadsheet is getting a 16 digit number with 5 dots (.). I'm getting desperate, because I haven't change nothing on the Configuration.

[Marce Castro]

Hi Thiago!

Did you get to fix this? I'm struggling finding a solution :-/

[toni.gv...@gmail.com]

Hi There!

I Just read this thread to try to fix that, I was having the same problem, but... Indeed my fix was do what Philip said:

Change the format of the spreadsheet into US format. How? Check that:

https://support.google.com/docs/answer/58515

Once you have changed the spreadsheet format to Locale: United States; then the add-on gives you a seconds format. 

Then you only need to make the formula. Imagine the Second value is in cell A1, so... In another cell you run "=A1(24*60*60)" hit enter, then go to cell format>duration

Voilá!