The Running Time Bank: Cumulative Balances, Upper & Lower Caps and Hours Lost
This lesson is part of the course
In this lesson
You build the uncapped running bank with an anchored SUM, apply the upper and lower caps with MIN and MAX, measure the hours lost above the cap each week and total them for the quarter in one SUMPRODUCT.
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