Core Hours: Late Starts, Early Finishes & Core-Hour Breaches by Team
This lesson is part of the course
In this lesson
You flag starts after the core window opens and finishes before it closes, count late starts per team with COUNTIFS and count every record that breaks the core window at least once, without counting a double breach twice.
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
- Daily Balances: Worked Hours, Breaks, Overnight Shifts & the Plus/Minus per Day Locked
- Core Hours: Late Starts, Early Finishes & Core-Hour Breaches by Team Locked
- The Running Time Bank: Cumulative Balances, Upper & Lower Caps and Hours Lost Locked
- Month-End Carry-Over: Carry Limits, Payout of Excess Hours & Balances to Recover Locked
- Time Off in Lieu: Balances into Days, Booking TOIL with WORKDAY and the Balance Left Locked
- Annualised Hours Contracts: ISO Weeks, Weekly Actuals, the Year-to-Date Gap & the Hours Still to Work Locked
- Part-Time Staff & Joiners: Pro-Rata Weekly, Daily and Annual Targets Locked
- Capstone: Team Time-Bank Report – Averages by Team, Review Flags by Location and the Bank Trend Locked