How to convert ga:avgSessionDuration to minutes:seconds

1,617 views

Skip to first unread message

Libor Matějka

unread,

Jan 7, 2016, 1:17:09 PM1/7/16

to google-analytics-spreadsheet-add-on

Hi,

how to convert ga:avgSessionDuration (or ga:sessionDuration) to minutes:sseconds format in Google Spreadsheets? I know it is type: TIME, but i do not know, how to format to minutes:seconds.

Thx

Ryan Praskievicz

unread,

Jan 7, 2016, 7:30:13 PM1/7/16

to google-analytics-spreadsheet-add-on

Hi Libor,

Here is a post on how to convert Google Analytics time metrics to minutes:seconds format in Google Sheets. Here is a sample Google Sheet with examples.

Best,

Ryan

Reply all

Reply to author

Forward

0 new messages