Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo29TimeNumberFormat.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo29TimeNumberFormat.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
In 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.
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:51) What is Excel Time Number Format?
3. (07:40) Excel Formula for Total Hours between two-time values
4. (11:27) Excel Formulas for Total Hours between four-time values, Time In and Time Out including Lunch break
5. (15:20) Payroll table with formulas for: Hours Worked, Gross Pay, Deductions, Net Pay, including the correct use of the Round Function
6. (18:51) Summary

Next Video: 30 Excel & Business Math