Banker's Rounding or Half Way Even Rounding (Excel, Power Query, VBA)

by excelisfun · 2 videos

Total watch time

24m 25s

at 1× speed · exactly 24 minutes, 25 seconds at 1×

custom

1×	24m 25s
1.25×	19m 32s
1.5×	16m 17s
1.75×	13m 57s
2×	12m 13s

Average video12m 13s

Longest13m 54s

Shortest10m 31s

Compare Open on YouTube JSON

Plan to finish

About 1 day at an hour a day

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

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

Videos (2)

24m 25s in total · tick what you've watched

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

Watched
	1	Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding	10:31	2016-10-23
	2	Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding	13:54	2010-02-24

Embed a badge

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

Markdown

[![Watch time: 24m 25s · 2 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0k594CmcLPozewiaQefZ-Wp.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0k594CmcLPozewiaQefZ-Wp)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0k594CmcLPozewiaQefZ-Wp"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0k594CmcLPozewiaQefZ-Wp.svg" alt="Watch time: 24m 25s · 2 videos" width="202" 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/PLrRPvpgDmw0k594CmcLPozewiaQefZ-Wp 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.