I imported a report to Google Sheets and the duration column shows
7 h 37 m or
14 h 5 m a similar format.
When I replace
: it still does not properly format to time duration and so I cannot average the time in total.
It appears oddly where some are formatted but others are not or look non-uniform.