Download Start Excel File: http:\/\/ift.tt\/2ol0qmU
\nDownload pdf Notes: http:\/\/ift.tt\/2C9onHg
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY
\nIn this video learn about Time Number Formatting and learn about Time Calculations in Excel to calculate Total Number Of Hours between two time values. Also see a Payroll table that allows us to calculate Hours Worked, Gross Pay, Deductions and Net Pay.
\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:51) What is Excel Time Number Format?
\n3. (07:40) Excel Formula for Total Hours between two-time values
\n4. (11:27) Excel Formulas for Total Hours between four-time values, Time In and Time Out including Lunch break
\n5. (15:20) Payroll table with formulas for: Hours Worked, Gross Pay, Deductions, Net Pay, including the correct use of the Round Function
\n6. (18:51) Summary<\/p>\n
Next Video: 30 Excel & Business Math<\/p>\n