Weekly Timesheet: Regular Hours, Overtime & Pay
This lesson is part of the course
In this lesson
You split Ava Moreno's weekly hours into regular and overtime hours with MIN and MAX, calculate her daily pay with the overtime factor and chart the week as a stacked column chart.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- How Excel Stores Dates: Serial Numbers, DATE, YEAR & TEXT Locked
- EDATE & EOMONTH: Renewals, Due Dates & Fiscal Periods Locked
- NETWORKDAYS & WORKDAY with Holidays and Custom Weekends Locked
- DATEDIF & YEARFRAC: Age, Tenure and Pro-Rata Amounts Locked
- WEEKDAY, WEEKNUM & ISOWEEKNUM: A Weekly Revenue Report Locked
- Time Math: Hours Worked, Overnight Shifts, MOD & ×24 Locked
- Weekly Timesheet: Regular Hours, Overtime & Pay Locked
- Project Schedule: WORKDAY Chains & a Gantt-Style Bar Chart Locked