Excel & Business Math 31: Night Shift Hours Worked Formula for Payroll Time Sheet (3 Examples)

Описание: Download Start Excel File: https://people.highline.edu/mgirvin/A...
Download pdf Notes: https://people.highline.edu/mgirvin/A...
Entire Class Web Site: https://people.highline.edu/mgirvin/A...

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    • Excel Magic Trick 1206: Day & Night Shift ...