Do You Have The Time?

When creating Google Analytics reports in Excel, time metrics like Avg Session Duration are delivered in seconds, but people want to see the number shown in minutes and seconds as “1:52” (instead of as “112” seconds). Attempts to format the number as “Time” in Excel prove frustrating because Excel expects time numbers to be fractions of a day, not […]

Continue reading