Calculate the Average Time Spent Viewing a Page

[TDog]

Hello all,  I'm trying to calculate the average time spent viewing a web page.  I have a column with the average time spent viewing a web page in a text format as '00:00:00'.  Id like to claculate the average time spent on each web page.  There are multiple entires of like web pages with different time spent durations.  My data columns are below:  Any help you can provide is greatly appreciated.  Many thanks!

[v-lionel-msft · Accepted solution]

Hi @TDog ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@TDog , You can split this and convert in second and take avg

time in second = left([Avg time on page],2)*3600 + mid([Avg time on page],4,2)*60 + right([Avg time on page],2)

else refer

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389