playlistduration

Excel Rounding Tricks

by excelisfun · 17 videos

Total watch time

1h 45m

at 1× speed · exactly 1 hour, 45 minutes, 12 seconds at 1×

1×1h 45m 12s
1.25×1h 24m 10s
1.5×1h 10m 8s
1.75×1h 7s
2×52m 36s
Average video6m 11s
Longest15m 18s
Shortest2m 10s
Compare Open on YouTube JSON

Plan to finish

About 2 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 2 days. Turn on JavaScript to plan around your week.

Videos (17)

1h 45m in total · tick what you've watched

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

Videos to
Watched
1 Highline Excel 2016 Class 25: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more… 8:34 2016-07-07
2 Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding 13:54 2010-02-24
3 Excel Magic Trick 379: Round to Nearest 1/10th Hour for Payroll 3:27 2009-09-04
4 Excel Magic Trick #395: When ROUND function Must Be Used 4:32 2009-09-25
5 Excel Magic Trick #237: ROUND to Digit or Multiple 4:54 2009-02-02
6 Excel Magic Trick #238: Round Times To 5 Minutes 4:35 2009-02-02
7 Excel Magic Trick 380: Negative Numbers Round To Nearest 5 2:10 2009-09-04
8 Excel Magic Trick 599: ROUND Only The Total Column Using SUM & ROUND Array Formula 3:35 2010-05-11
9 Excel 2010 Business Math 26.5: Rounding Percentages 5:03 2011-10-17
10 Mr Excel & excelisfun Trick 92: Round Invoice: ROUND or SUMPRODUCT - ROUND 4:09 2011-12-03
11 Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH 8:34 2012-03-02
12 Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal) 3:10 2012-02-29
13 Excel Magic Trick 875: Lookup Bond Score Based On Years and Rate: 2-Way Lookup With Rounding 15:18 2012-03-02
14 Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment 2:28 2013-07-16
15 Excel Magic Trick 1030: Round To The Nearest $50 For Pricing or To The Nearest Second For Times 4:28 2013-08-01
16 Excel Magic Trick 1078: Total Cost Based On Per Minute Charge & Excel Time Values Nearest 15 Seconds 5:50 2014-02-28
17 Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding 10:31 2016-10-23

Embed a badge

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

Watch time: 1h 45m · 17 videos

Markdown
[![Watch time: 1h 45m · 17 videos](https://playlistduration.com/badge/playlist/PLB08688D95A8E5C93.svg)](https://playlistduration.com/playlist/PLB08688D95A8E5C93)
HTML
<a href="https://playlistduration.com/playlist/PLB08688D95A8E5C93"><img src="https://playlistduration.com/badge/playlist/PLB08688D95A8E5C93.svg" alt="Watch time: 1h 45m · 17 videos" width="203" 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/PLB08688D95A8E5C93 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.