I am interested in configuring a calculated metric for use in the pages report to provide end users with an easy to read and understand metric titled Average Page View Time in hh:mm:ss format rather than the out of box Time Spent or Average Time Spent on Page metric which includes custom logic and displays the result in minutes (ie. 1.88).
Here is my current approach:
Format: Time
Summary: Total Seconds Spent / (Visits - Single Page Visits)
OR
Format: Time
Summary: Total Seconds Spent / (Visits - (Bounces+Exits))
To Calculate Minutes
Format: Decimal (Decimal Places = 2)
((Total Seconds Spent / (Visits - Single Page Visits)) / 86400) * 1440
