playlistduration

Excel Payroll & Time Tricks

by excelisfun · 62 videos

Total watch time

11h 25m

at 1× speed · exactly 11 hours, 24 minutes, 58 seconds at 1×

1×11h 24m 58s
1.25×9h 7m 58s
1.5×7h 36m 39s
1.75×6h 31m 25s
2×5h 42m 29s
Average video11m 3s
Longest1h 21m 14s
Shortest1m 14s
Compare Open on YouTube JSON

Plan to finish

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

Videos (62)

11h 25m 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 501: Excel Time Format & Calculations (10 Examples) 13:08 2010-02-05
2 Excel & Business Math 29: Time Number Formatting & Time Calculations in Excel for Payroll Table 19:59 2018-02-20
3 Excel & Business Math 30: Payroll Time Sheets, IF Function, Sheet Reference for Overtime & Gross Pay 21:43 2018-02-21
4 Excel & Business Math 31: Night Shift Hours Worked Formula for Payroll Time Sheet (3 Examples) 20:44 2018-02-22
5 Excel & Business Math 32: Rounding Time Calculations to Nearest 5 or 15 minutes using MROUND 15:31 2018-02-22
6 Excel & Business Math 33: VLOOKUP Function for Incentive Pay: Commissions & Piecework (15 Examples) 1:21:14 2018-02-25
7 Excel & Business Math 34: MEDIAN Function for FICA Social Security & Medicare Payroll Deductions 38:58 2018-02-27
8 Excel & Business Math 35: VLOOKUP & MAX Functions for Percentage Method Federal Income Tax Deduction 29:36 2018-03-01
9 Excel & Business Math 36: Comprehensive Excel Payroll Example: SUMIFS, MROUND, MOD, VLOOKUP & More 28:44 2018-03-02
10 Excel Magic Trick 727: Calculate Hours Worked Night or Day Shift With Break For Lunch 5:36 2010-09-27
11 Excel Busn Math 04: The Importance Of Formatting In Math 14:05 2009-02-03
12 Excel Busn Math 07: When ROUND function Is Required 9:11 2009-02-03
13 Excel Basics #15: Date & Time Format & Calculations 7:51 2008-12-16
14 Excel Busn Math 38: Gross Pay and Overtime: 5 Examples 30:05 2009-04-26
15 Excel Busn Math 41: Payroll Deductions With Ceilings (FICA) 18:34 2009-04-26
16 YouTubersLoveExcel#23: Add Time with Formula or Format 5:55 2008-05-30
17 YouTubersLoveExcel#24: Add Time by Hour, Minute or Day 3:02 2008-05-30
18 Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time) 7:43 2009-03-16
19 Excel Magic Trick 298: MOD function Formula for Total Time Worked 2:28 2009-03-23
20 Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays 1:45 2009-11-02
21 Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.) 10:01 2009-11-02
22 Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010 2:11 2009-11-02
23 YTLE#77: INDEX INDIRECT MATCH functions for Payroll 9:01 2008-07-30
24 Excel Lookup Series #9: INDEX function 1st Example 3:15 2008-04-30
25 Excel Magic Trick #173: Time Over or Under (Negative Time) 7:57 2008-12-30
26 YouTubersLoveExcel#48: VLOOKUP for TIME 7:38 2008-06-27
27 Excel Magic Trick 299: Date & Time Number - Total Days & Hours Formula 5:16 2009-03-23
28 Excel Magic Trick 500: Years Worked Formula YEARFRAC, INT, DATEDIF functions 2:32 2010-02-05
29 Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekends 4:52 2010-02-26
30 Excel Magic Trick 598: Hours Worked In Day Including Lunch Breaks 3:18 2010-05-11
31 Excel Magic Trick 600: Convert Hours to Days & Hours using MOD & INT functions 3:23 2010-05-11
32 Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunch 12:23 2010-09-09
33 Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AM 4:53 2010-09-09
34 Excel Magic Trick 766: Count Times Before And After A Stated Time. 4:58 2011-03-09
35 Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND 8:09 2011-03-31
36 Excel Magic Trick 855: Change Military Time To Non-Military Time (Time Number Formatting) 1:14 2012-01-13
37 Excel Magic Trick 885: Calculate Payroll Penalty For Every 15 Minute Late QUOTIENT & MOD 9:00 2012-03-21
38 Excel Magic Trick 885.5: Part 2 Calculate Payroll Penalty QUOTIENT & OR & Array Constant 4:33 2012-03-22
39 Excel Magic Trick 1057: Calculate Hours Worked From Text Time Values, Including Night Shift 6:43 2013-12-27
40 Excel Magic Trick 1076: Convert Date-Time Values to Serial Numbers w TEXT & Custom Number Format 3:36 2014-02-26
41 Excel Magic Trick 1078: Total Cost Based On Per Minute Charge & Excel Time Values Nearest 15 Seconds 5:50 2014-02-28
42 Excel Magic Trick 1168: Get Time Value From Date Time Value (2 Formula Examples) 3:00 2014-12-05
43 Excel Magic Trick 1206: Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula 10:35 2015-07-16
44 Excel Magic Trick 1228: Hours Worked Formula For Date & Time Values & Time Custom Number Format 4:06 2015-08-18
45 Excel Magic Trick 1250: Add Times to Get Total Minutes & Seconds From Downloaded Music Data 11:29 2016-01-07
46 Excel Magic Trick 1262: Convert Times Values to HHMM Text or Text HHMM Values to Time Values 3:48 2016-01-24
47 Excel Magic Trick 1264: Gross Pay From Start & End Date, Weekends Sun & Mon and Weekly Pay Scale 4:09 2016-01-28
48 Excel Magic Trick 1265: NETWORKDAYS.INTL Function: Calculate Net Workdays (8 examples) 7:53 2016-01-29
49 Excel Magic Trick 1266: NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule? 4:50 2016-01-30
50 Excel Magic Trick 1359: Split Times Values Into 8 Equal Zones: VLOOKUP, LOOKUP or INT/HOUR? 17:10 2016-12-21
51 Excel Magic Trick 1416: Round Up to 15 or 30 Minute Increments for Hours Worked Time Calculations 11:17 2017-05-08
52 Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples) 16:08 2017-08-23
53 Excel & Business Math 32: Rounding Time Calculations to Nearest 5 or 15 minutes using MROUND 15:31 2018-02-22
54 Excel Magic Trick 1512: Count Workers Employed 1 to 6 Years Based on Hire Date? 9 Examples 14:36 2018-08-10
55 Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS 7:09 2019-02-14
56 Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun 17:11 2020-08-14
57 MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705. 9:11 2020-12-01
58 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753 1:58 2021-09-13
59 Create Sequence of Time Values in Excel for Stock Market Price Data – Excel Magic Trick 1798 7:18 2022-08-15
60 Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826 6:55 2023-07-11
61 3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827 8:54 2023-07-16
62 Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838. 5:15 2023-09-10

Embed a badge

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

Watch time: 11h 25m · 62 videos

Markdown
[![Watch time: 11h 25m · 62 videos](https://playlistduration.com/badge/playlist/PL2359D28773B08D86.svg)](https://playlistduration.com/playlist/PL2359D28773B08D86)
HTML
<a href="https://playlistduration.com/playlist/PL2359D28773B08D86"><img src="https://playlistduration.com/badge/playlist/PL2359D28773B08D86.svg" alt="Watch time: 11h 25m · 62 videos" width="210" 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/PL2359D28773B08D86 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.