Excel Magic Trick 885.5: Part 2 Calculate Payroll Penalty QUOTIENT & OR & Array Constant

3,331 views · Published 22 March 2012 · 4:33 · Indexed 5 October 2026

Channel: excelisfun · 2012 · Education

Watch on YouTube

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT885.5.xlsm

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to build a formula to calculate late penalty for every 15 minutes that an employee is late using Time Math and the functions QUOTIENT & MINUTE & OR Functions and Array Constant

Related Video:

Excel Magic Trick 885: Calculate Payroll Penalty For Every 15 Minute Late QUOTIENT & MOD

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,557 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,595 views · 30 May 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,876 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,905 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008

• 5:07 YTLE#63: Array Formula: Vendor Max Rating Min Cost

  excelisfun

  2,134 views · 23 July 2008

• 3:50 YTLE#68: 3 Ways To Use Fill Handle for Copying

  excelisfun

  2,472 views · 28 July 2008