Simple Excel Function to Combine Values in ALL Versions of Excel - UDF

by TeachExcel · published 2019-06-04

Total watch time

35m 3s

at speed · exactly 35 minutes, 3 seconds at 1×

35m 3s
1.25×28m 2s
1.5×23m 22s
1.75×20m 2s
17m 32s
Compare Open on YouTube JSON

Embed a badge

Show the length in a README or course description — it links back here and updates itself

Length: 35m 3s

Markdown
[![Length: 35m 3s](https://playlistduration.com/badge/video/OZECSRslbPE.svg)](https://playlistduration.com/video/OZECSRslbPE)
HTML
<a href="https://playlistduration.com/video/OZECSRslbPE"><img src="https://playlistduration.com/badge/video/OZECSRslbPE.svg" alt="Length: 35m 3s" width="110" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/video/OZECSRslbPE returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached).