Flexitime & Time Banks: Daily Balances, Core Hours, Carry-Over Caps, Time Off in Lieu & Annualised Hours Contracts
Keep flexible working hours fair and transparent under a fictional policy. You will compute daily plus/minus balances, check core-hour presence, run time-bank balances with caps, convert extra hours into time off or payout, plan annualised hours across a year and report balances by team, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you run the flexitime accounts of a fictional instrument maker in a spreadsheet, with every formula checked. You turn start and end times into worked hours, handle overnight shifts with MOD and show balances as plus or minus hours. You flag late starts and early finishes against core hours with COUNTIFS, run a time bank with upper and lower caps, and close the month with carry-over limits and payouts. You convert balances into half days of time off in lieu with WORKDAY, track an annualised hours contract by ISO week, pro-rate targets for part-time staff and joiners, and report balances by team and location.
Lessons
- Daily Balances: Worked Hours, Breaks, Overnight Shifts & the Plus/Minus per Day Pro
- Core Hours: Late Starts, Early Finishes & Core-Hour Breaches by Team Pro
- The Running Time Bank: Cumulative Balances, Upper & Lower Caps and Hours Lost Pro
- Month-End Carry-Over: Carry Limits, Payout of Excess Hours & Balances to Recover Pro
- Time Off in Lieu: Balances into Days, Booking TOIL with WORKDAY and the Balance Left Pro
- Annualised Hours Contracts: ISO Weeks, Weekly Actuals, the Year-to-Date Gap & the Hours Still to Work Pro
- Part-Time Staff & Joiners: Pro-Rata Weekly, Daily and Annual Targets Pro
- Capstone: Team Time-Bank Report – Averages by Team, Review Flags by Location and the Bank Trend Pro