Download Excel File: [ Ссылка ]
This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Girvin at Highline Community College.
In this video learn how to calculate:
1. Time Number Format and Time Math
2. Complete Payroll Time Sheets in Excel for Employees
3. Learn how to do a Sheet Reference In Excel Formulas
4. IF Function for Overtime Calculation
5. Calculate Gross Pay from Time Sheets
Related videos:
Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)
Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)
Excel Magic Trick 727: Calculate Hours Worked Night or Day Shift With Break For Lunch

свернуть