playlistduration

Excel Series: Magic Tricks (3rd 200 videos)

by excelisfun · 200 videos

Total watch time

21h 51m

at 1× speed · exactly 21 hours, 50 minutes, 43 seconds at 1×

1×21h 50m 43s
1.25×17h 28m 34s
1.5×14h 33m 49s
1.75×12h 28m 59s
2×10h 55m 22s
Average video6m 33s
Longest36m 40s
Shortest1m 20s
Compare Open on YouTube JSON

Plan to finish

About 22 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 22 days. Turn on JavaScript to plan around your week.

Videos (200)

21h 51m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Magic Trick 379: Round to Nearest 1/10th Hour for Payroll 3:27 2009-09-04
2 Excel Magic Trick 380: Negative Numbers Round To Nearest 5 2:10 2009-09-04
3 Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature 4:27 2009-09-10
4 Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List 6:26 2009-09-10
5 Excel Magic Trick 383:Conditional Formatting Between a Max and Min 4:07 2009-09-10
6 Excel Magic Trick 384: Keyboard Shortcut To Highlight 1000 Cells 2:21 2009-09-10
7 Excel Magic Trick 385: Generate Random Letters without RANDBETWEEN function 3:04 2009-09-10
8 Excel Magic Trick 386: Less Than the Letter M Conditional Formatting 3:59 2009-09-10
9 Excel Magic Trick 387: Data Validation Drop-Down List & Cell References 2:49 2009-09-17
10 Excel Magic Trick 388: Conditional Formatting and the Active Cell 3:29 2009-09-17
11 Excel Magic Trick 389: Ctrl + Period Keyboard Shortcut 1:20 2009-09-17
12 Excel Magic Trick 390: Increment Word & Number 2 Methods. 3:26 2009-09-17
13 Excel Magic Trick 391: Custom Number Format to Insert Symbol Automatically 1:55 2009-09-17
14 Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blank 3:24 2009-09-17
15 Excel Magic Trick 393: Remove Last Two Words From Column Of Data 11:06 2009-09-17
16 Excel Magic Trick #394: IF Function and Conditional Formatting 5:04 2009-09-26
17 Excel Magic Trick #395: When ROUND function Must Be Used 4:32 2009-09-25
18 Excel Magic Trick #396: COUNTIF function and Multiplying 2:17 2009-09-25
19 Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics) 4:25 2009-09-25
20 Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values 4:54 2009-10-08
21 Excel Magic Trick 399: NA Error Trouble in Array Formula 2:41 2009-10-08
22 Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down 7:22 2009-10-08
23 Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable) 6:10 2009-10-08
24 Excel Magic Trick 402: Monthly Comparative Report - Pivot Table 3:52 2009-10-08
25 Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table 8:32 2009-10-08
26 Excel Magic Trick 404: Quarterly Comparative Report SUMIFS function 6:47 2009-10-08
27 Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function 4:41 2009-10-08
28 Excel Magic Trick 406: Add 1 Extra For Each Deposit 1:26 2009-10-09
29 Excel Magic Trick 407: Amortization Table W Variable Rate 14:07 2009-10-14
30 Excel Magic Trick 408: VLOOKUP MIN Value 2:08 2009-10-14
31 Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record 10:13 2009-10-14
32 Excel Magic Trick 410: VLOOKUP: Convert Web Query Result 78.9k to 78,900 5:53 2009-10-14
33 Excel Magic Trick 411: Expandable Ranges In SUMIFS function. 4:38 2009-10-14
34 Excel Magic Trick 412: Data Validation Drop Down List & OFFSET function 4:13 2009-10-14
35 Excel Magic Trick 413: Copied Web Site Data Trouble CLEAN TRIM Text To Columns 5:37 2009-10-14
36 Excel Magic Trick 414: Retroactive Dynamic Ranges! 5:37 2009-10-14
37 Excel Magic Trick 415: Summarize Survey Results 2 Different Methods 10:31 2009-10-19
38 Excel Magic Trick 416: Add Invoices w Same Prefix (Number v Text problem examined) 5:29 2009-10-19
39 Excel Magic Trick 417: Get Last Value from Multiple Sheets 5:04 2009-10-19
40 Excel Magic Trick 418: Reference Every Third Value 2:32 2009-10-19
41 Excel Magic Trick 419: Add Two Largest, But Skip Columns C & E 5:31 2009-10-19
42 Excel Magic Trick 420: VLOOKUP w SUM function in 3rd argument (Football Betting Table) 6:10 2009-10-19
43 Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Value 4:24 2009-10-19
44 Excel Magic Trick 422: Conditional Formatting 1st Two Rows Regardless of Sort 3:32 2009-10-19
45 Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function 3:53 2009-10-26
46 Excel Magic Trick 424: Conditional Formatting For Dynamic Range 6:31 2009-10-26
47 Excel Magic Trick 425: Functions That Can Handle Array Syntax And Do Not Require CSE 8:02 2009-10-26
48 Excel Magic Trick 426: VLOOKUP to Assign Category To A Sales Number 1:58 2009-10-26
49 Excel Magic Trick 427: Determine Day Name For Future Date 6:13 2009-10-26
50 Excel Magic Trick 428: Trouble Entering Dates - Date Syntax 2:29 2009-10-26
51 Excel Magic Trick 429: Count IDs that Are the Equivalent (DELTA function) 3:21 2009-10-26
52 Excel Magic Trick 430: Count Sales Numbers Greater Than Hurdle (GESTEP function) 2:55 2009-10-26
53 Excel Magic Trick 431: Excel 4 GET.CELL Macro Function 10:16 2009-11-02
54 Excel Magic Trick 432: Find & Extract Duplicate Records 3:28 2009-11-02
55 Excel Magic Trick 433: Custom Number Format for Showing Numbers Rounded to Thousands Position 3:31 2009-11-02
56 Excel Magic Trick 434: Extract Completed Records with Formula 8:16 2009-11-02
57 Excel Magic Trick 435: Extract Duplicate Records with Formula 5:53 2009-11-02
58 Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns 6:43 2009-11-02
59 Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays 1:45 2009-11-02
60 Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation 6:55 2009-12-08
61 Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.) 10:01 2009-11-02
62 Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010 2:11 2009-11-02
63 Excel Magic Trick 440: Array Formulas Advanced Tips 23:15 2009-11-16
64 Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.) 2:51 2009-11-16
65 Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods 10:29 2009-11-19
66 Excel Magic Trick 443: SUMIF Cumulative Sales Formula & Pivot Table Cumulative Sales Table 4:50 2009-11-16
67 Excel Magic Trick 444: Multiply Column Times Row With TRANSPOSE Function 1:21 2009-11-16
68 Excel Magic Trick 445: Complicated Criteria for MODE calculation LOOKUP 8:17 2009-11-16
69 Excel Magic Trick 446: Time In & Time Out in Same Cell Bad Setup Leads To Complicated Formula 7:39 2009-11-16
70 Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet 6:11 2009-11-16
71 Excel Magic Trick 448: OFFSET Function To Avoid #REF! Error 2:58 2009-11-16
72 Excel Magic Trick 449: Excel Data Analysis Abbreviated Notes 13:00 2009-11-16
73 Excel Magic Trick 450: Number Formatting Abbreviated Notes (House Paint or Halloween Mask) 4:22 2009-11-16
74 Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup 5:16 2009-11-16
75 Excel Magic Trick 452: IF Function Formula 16 Examples 36:40 2009-11-30
76 Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also) 8:01 2009-11-30
77 Excel Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions 10:24 2009-12-01
78 Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total 9:06 2009-11-30
79 Excel Magic Trick 456: Add Only Integer Part SUM & INT functions 1:36 2009-11-30
80 Excel Magic Trick 457: SUMPRODUCT & OR Criteria 5:27 2009-11-30
81 Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math 11:53 2009-12-08
82 Excel Magic Trick 459: Non-Zero numbers = TRUE IF Function logical_test Argument Tricks 6:33 2009-12-08
83 Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions 3:11 2009-12-08
84 Excel Magic Trick 461: Progress Toward Goal Chart or Thermometer Chart 4:02 2009-12-08
85 Excel Magic Trick 462:Show Formula Formula - Excel 4 Macro Function GET.CELL 5:02 2009-12-08
86 Excel Magic Trick 463: 4 ways to Add New Data To A Chart 4:36 2009-12-08
87 Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation 6:55 2009-12-08
88 Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions 5:49 2010-01-01
89 Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format) 3:55 2010-01-01
90 Excel Magic Trick 468: Count Spaces at Beginning & End of Text String (Array Formula) 6:01 2010-01-01
91 Excel Magic Trick 469: VLOOKUP for Horsepower Calculation 2:58 2010-01-01
92 Excel Magic Trick 470: Formula For Days In Any Given Month 4:05 2010-01-01
93 Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples 4:48 2010-01-01
94 Excel Magic Trick 472: Count Spaces at Beginning & End of Text String Simple Formula 3:52 2010-01-05
95 Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) 17:44 2010-01-05
96 Excel Magic Trick 474: Conditional Format At Every Change In Value 1:52 2010-01-05
97 Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculation 1:30 2010-01-08
98 Excel Magic Trick 477: 13 Digit Number ID Shows Scientific Notation!? 1:44 2010-01-08
99 Excel Magic Trick 476: SUMPRODUCT Function for Weighted Average Cost From Transaction Data 4:52 2010-01-08
100 Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers 9:33 2010-01-12
101 Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations 14:42 2010-01-12
102 Excel Magic Trick 480: Percentage Of Total - Formula or PivotTable (Pivot Table) 7:31 2010-01-12
103 Excel Magic Trick 481: Change Operator in Formula from Drop-Down Using CHOOSE function 3:00 2010-01-14
104 Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheet 5:25 2010-01-14
105 Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers 4:50 2010-01-14
106 Excel Magic Trick 484: Stop Automatic Copyright symbol © 2:41 2010-01-29
107 Excel Magic Trick 485: Create Shorthand to speed up typing using AutoCorrect 3:23 2010-01-29
108 Excel Magic Trick 486: Avoid #DIV/0! Error in Formula 4 Examples (Divide By Zero Error) 6:34 2010-01-29
109 Excel Magic Trick 487: Hyperlink That Opens Different Workbook or Goes To Different Sheet 2:59 2010-01-29
110 Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors 12:17 2010-01-29
111 Excel Magic Trick 490: Conditional Format for Budget Less Than $500. 5:27 2010-02-02
112 Excel Magic Trick 491: Count Matches in Individual Cells 2:28 2010-02-02
113 Excel Magic Trick 492: Count Matches in Single Cell 7:01 2010-02-02
114 Excel Magic Trick 493: Repeat a List of Names 7 times 7:09 2010-02-02
115 Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula 10:36 2010-01-29
116 Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples) 24:36 2010-02-09
117 Excel Magic Trick #503: Custom Number Format For Turnover Ratio 1:42 2010-02-08
118 Excel Magic Trick #504: 3D Formatting For Cells Using Borders 2:41 2010-02-08
119 Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble 8:19 2010-02-08
120 Excel Magic Trick #506: Summarize Data - Multiple Sheets & Banks Accounts - Checkbook Register 24:43 2010-02-11
121 Excel Magic Trick #507: Fix Bad Data So We Can Add With Two Criteria & Make Summary Report 10:44 2010-02-11
122 Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function 12:15 2010-02-17
123 Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature 12:01 2010-02-17
124 Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changed 7:57 2010-02-17
125 Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters 5:45 2010-02-17
126 Excel Magic Trick 512: Frugal Bargain Hunters - Series Discounts to Calculate Total Savings 4:59 2010-02-17
127 Excel Magic Trick 513: Equivalent Earnings Simple Formula 2:56 2010-02-17
128 Excel Magic Trick 514: Conditional Formatting Duplicate Values (3 Methods) 5:00 2010-02-21
129 Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creation 9:17 2010-02-21
130 Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References 3:12 2010-02-23
131 Excel Magic Trick 517: Vendor Name For Low Bid & % Cheaper Than Next Lowest Bid Formula 8:42 2010-02-23
132 Excel Magic Trick 518: Show Multiple Vendor Names Associated With Low Bid Array Formula INDEX 8:06 2010-02-23
133 Excel Magic Trick 519: SUBSTITUTE & REPLACE Functions 11:29 2010-02-23
134 Excel Magic Trick 520: FIND & SEARCH Functions 9:54 2010-02-23
135 Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding 13:54 2010-02-24
136 Excel Magic Trick 522: 30 Days In Each Month Calculations 3:47 2010-02-23
137 Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number 1:40 2010-02-23
138 Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods 25:52 2010-02-24
139 Excel Magic Trick 525: Advanced Filter With Wild Cards 2:15 2010-02-24
140 Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functions 8:55 2010-02-24
141 Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH 6:29 2010-02-24
142 Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions 7:17 2010-02-24
143 Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Product 5:33 2010-02-24
144 Excel Magic Trick 530: Does Text String Contain Repair OR Rework? OR SEARCH ISNUMBER functions 3:15 2010-02-24
145 Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods) 8:12 2010-02-26
146 Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions 10:29 2010-02-26
147 Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekends 4:52 2010-02-26
148 Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays 8:05 2010-03-02
149 Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function 7:58 2010-03-02
150 Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL 5:57 2010-03-02
151 Excel Magic Trick 537: Drill Through Spreadsheets -- Formatting, Formulas, Editing 4:17 2010-03-05
152 Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through 11:33 2010-03-05
153 Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method 5:50 2010-03-12
154 Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method 8:33 2010-03-12
155 Excel Magic Trick 541: Get Last Price In Column Based On Criteria In Other Columns 4:29 2010-03-12
156 Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document 7:01 2010-03-12
157 Excel Magic Trick 543: Build Time Schedule With 15 Minute Intervals 1:49 2010-03-12
158 Excel Magic Trick 544: Conditional Formatting Row With Multiple Criteria In Other Columns 4:39 2010-03-12
159 Excel Magic Trick 545: Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCT 4:46 2010-03-12
160 Excel Magic Trick 546: Is Item List? Case Sensitive OR & EXACT functions 2:41 2010-03-12
161 Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computer 5:01 2010-03-12
162 Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet 7:11 2010-03-12
163 Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature? 10:58 2010-03-12
164 Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Dependent DV 6:39 2010-03-12
165 Excel Magic Trick 551: Count Mondays or Sundays or Tuesdays, etc. Between Start & End Date 7:34 2010-03-23
166 Excel Magic Trick 552: Display VLOOKUP Results Vertically 5:35 2010-03-23
167 Excel Magic Trick 553: SUMIF for Dollars and Euros 4:03 2010-03-23
168 Excel Magic Trick 554: Conditional Formatting for Weekends and Holidays Better than EMT 534 4:27 2010-03-23
169 Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculations 3:04 2010-03-23
170 Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table) 4:41 2010-03-23
171 Excel Magic Trick 557: CHOOSE function to lookup Formula or Function (2 Examples). 9:44 2010-03-23
172 Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table 6:56 2010-03-27
173 Excel Magic Trick 559: Extract Nth Word In Text String 13:18 2010-03-27
174 Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font White 2:32 2010-03-27
175 Excel Magic Trick 561: Wildcards * and ? 4:45 2010-03-27
176 Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not 7:50 2010-03-27
177 Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions 2:22 2010-04-04
178 Excel Magic Trick 564: Daily Gantt Chart 8:33 2010-04-05
179 Excel Magic Trick 565: Excel 2010 Daily Gantt Chart 11:14 2010-04-05
180 Excel Magic Trick 566: Conditional Format A Chart Student Grades 5:00 2010-04-05
181 Excel Magic Trick 567: Collapsible Expandable Cell Ranges 2:31 2010-04-05
182 Excel Magic Trick 568: SUMIFS function Monthly Running Total from Transaction Data 9:06 2010-04-09
183 Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formula 11:45 2010-04-09
184 Excel Magic Trick 570: Remove Duplicate Records Excel 2007 / 2010 Feature 1:46 2010-04-16
185 Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import 9:06 2010-04-16
186 Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax 8:21 2010-04-16
187 Excel Magic Trick 573: VLOOKUP & OR functions For Filtering Data With Categories of Criteria 4:49 2010-04-16
188 Excel Magic Trick 574: Array Formula For Filtering Data With Categories of Criteria 12:12 2010-04-16
189 Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes 7:36 2010-04-23
190 Excel Magic Trick 576: Dynamic Break Even Chart using INDEX and MATCH functions 11:21 2010-04-23
191 Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records 6:28 2010-04-23
192 Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Exists 4:13 2010-04-23
193 Excel Magic Trick 565: Excel 2010 Daily Gantt Chart 11:14 2010-04-05
194 Excel Magic Trick 564: Daily Gantt Chart 8:33 2010-04-05
195 Excel Magic Trick 579: MOD function and Date Math Each Successive Date Is Repeated Twice 2:42 2010-04-27
196 Excel Magic Trick 580: Extract Digits To Right Of Decimal Into Individual Cells 6:03 2010-04-27
197 Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter 4:02 2010-04-27
198 Excel Magic Trick 582: Excel Errors 9 Types - What They Mean - How To Fix Them 7:48 2010-04-30
199 Excel Magic Trick 583: AVERAGEIF & IFERROR functions Mixed Cell References Gross Profit Percentage 6:35 2010-04-30
200 Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names 9:45 2010-04-30

Embed a badge

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

Watch time: 21h 51m · 200 videos

Markdown
[![Watch time: 21h 51m · 200 videos](https://playlistduration.com/badge/playlist/PL89875B1711B68B36.svg)](https://playlistduration.com/playlist/PL89875B1711B68B36)
HTML
<a href="https://playlistduration.com/playlist/PL89875B1711B68B36"><img src="https://playlistduration.com/badge/playlist/PL89875B1711B68B36.svg" alt="Watch time: 21h 51m · 200 videos" width="217" 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/playlist/PL89875B1711B68B36 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.