Time Math: Hours Worked, Overnight Shifts, MOD & ×24
This lesson is part of the course
In this lesson
You calculate shift lengths that cross midnight with MOD, convert times into decimal paid hours, round them to the nearest quarter hour and show a total above 24 hours correctly.
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