Download Excel File: Learn about the MOD function in the Excel Worksheet and the function in the Power Query M Code language. Learn how to use the MOD function for the Nightshift Hours Worked Payroll Calculation and how to create the Sequential numbers 1, 2, 3, 1, 2, 3. Topics: 1. (00:00) Intro. 2. (00:09) What is Mod? 3. (00:51) Division formula. 4. (01:11) QUOTIENT Worksheet Function. 5. (01:07) MOD Worksheet Function. 6. (02:12) Use Power Query to divide, quotient and modulo using Add Column built-in options. 7. (03:54) Algorithms for MOD and functions. See why they give different answers. 8. (05:41) Nightshift hours worked formula using MOD function. This time formula works for time calculations that are within a 24 hour day or that crosses midnight. 9. (07:35) Create Patterned Number Sequences such as 1, 2, 3, 1, 2, 3… 10. (08:33) Summary, Closing and Video Links