Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo31NightShift.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo31NightShift.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
In this video learn about three different formulas for n Excel Payroll Time Sheet with the Night Shift Employees work past midnight and have a Time Out that is smaller than the Time In.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:13) What is Night Shift?
3. (01:12) Look at Time Values for Night Shift and Negative Times in Excel
4. (05:18) Formula # 1 using IF Function
5. (09:41) Formulas #2 using Logical Formula or Boolean Formula
6. (13:29) Formula #3 using MOD Function
7. (14:57) Complete Payroll Time Sheet for Day or Night Shift using all three formulas and the ROUND Function.
8. (19:43) Summary
Next Video: 32 Excel & Business Math
Reference video for how MOD Formula works: Excel Magic Trick 1206: Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula https://www.youtube.com/watch?v=VcgSkLpgo6o