Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo30ExcelTimeSheets.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo30ExcelTimeSheets.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
In this video learn how to create Daily Time Sheets for the whole week, then use Sheet References, the IF Function and the ROUND Function to calculate the correct Gross Pay, including Overtime, for each Employee.
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. (01:04) Formula For Daily Employee Total Hours Worked
3. (04:57) Summary Table of Employee Hours for the Week
4. (07:47) Sheet Reference to pull Employee Weekly Hour Total to Gross Pay Sheet
5. (11:38) IF Function to calculate the correct Regular Hours for each Employee
6. (15:52) Overtime Hours Worked Formulas
7. (16:46) Regular Hours Gross Pay with ROUND Function
8. (18:26) Overtime Gross Pay with ROUND Function
9. (19:56) Total Gross Pay for each Employee for the week
10. (20:14) Summary
Next Video: 31 Excel & Business Math