Download Start Excel File: http:\/\/ift.tt\/2EHj4jT
\nDownload pdf Notes: http:\/\/ift.tt\/2CCS6DT
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY<\/p>\n
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.
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction
\n2. (00:13) What is Night Shift?
\n3. (01:12) Look at Time Values for Night Shift and Negative Times in Excel
\n4. (05:18) Formula # 1 using IF Function
\n5. (09:41) Formulas #2 using Logical Formula or Boolean Formula
\n6. (13:29) Formula #3 using MOD Function
\n7. (14:57) Complete Payroll Time Sheet for Day or Night Shift using all three formulas and the ROUND Function.
\n8. (19:43) Summary<\/p>\n
Next Video: 32 Excel & Business Math<\/p>\n