This free Excel workbook logs four weeks of hours for each part-timer and flags who is on a continuous contract under Hong Kong’s 468 rule: at least 17 hours in each week, or 68 hours or more across a short week and the three weeks before it, for weeks from 18 January 2026. [1]
What Is in the 468 Tracker Template?
The download is one Excel workbook with three sheets. There is no sign-up.
| Sheet | What it holds |
|---|---|
| Tracker | One row per employee. Columns: Employee, Role, Wk 1 hrs, Wk 2 hrs, Wk 3 hrs, Wk 4 hrs, 4-wk total, Every week ≥17?, 4-wk total ≥68?, Continuous contract?, Entitlements unlocked, Notes. Two shaded example rows to overwrite, then 16 blank rows with the formulas already in place. |
| How the 468 rule works | A short explainer of the weekly test and the aggregate test, a line on the old 418 rule, and the list of benefits that depend on continuous-contract status. |
| Sources | Links to the government’s 1823 FAQ on continuous contracts and two law-firm articles on the change. |
How Do You Use the 468 Tracker?
- Enter each part-time or casual employee and their role. Delete or overwrite the two example rows first.
- Log each week’s hours, with Wk 4 as the latest week. For this test a week ends on Saturday (Sunday to Saturday). [3] Take hours from timesheets. Hours on statutory leave, or on leave you agreed with the employee, count as hours worked. [2]
- Read the flags. “Continuous contract?” shows Yes if every week reaches 17 hours or the four-week total reaches 68.
- Save a dated copy each week before you roll the columns. Move the figures one column left so the oldest week drops off and Wk 4 holds the new one.
What Should You Watch For?
- New starters. The sheet does not know start dates. In the first three weeks of a new job the 68-hour route is not available, so each of those weeks needs 17 hours on its own. [2] Use the Notes column to mark new starters.
- Which four weeks count. A short week is judged with the three weeks before it. Keep Wk 4 as the latest week, roll the columns weekly, and keep the dated copies as your week-by-week record.
- Entitlements unlocked. Read that column as a watch list. Each benefit keeps its own eligibility conditions, so a Yes does not mean the employee is owed all of them today. [1]
For a one-employee check, the Labour Department’s Education Tool on New “Continuous Contract” Requirement walks through up to ten weeks of hours. The tracker is for a whole roster you can save and share. [2]
New to the rule? Read what the 468 rule means for continuous contracts.
Sources (accessed 5 Nov 2026, UTC+8)
- Labour Department, “Revise the ‘Continuous Contract’ Requirement under the Employment Ordinance”. https://www.labour.gov.hk/eng/news/EAO2025.htm
- Labour Department, “Education Tool on New ‘Continuous Contract’ Requirement” (Notes 1 and 2, and leave note). https://www.labour.gov.hk/eng/labour/Continuous_Contract_EduTool.htm
- Hong Kong e-Legislation, Employment Ordinance (Cap. 57), First Schedule (“Continuous Employment”), paragraphs 2A and 7. https://www.elegislation.gov.hk/hk/cap57!en
This Senior HR Forum page and template are based on public Labour Department material. They are general information, not legal advice, and the spreadsheet is not an official calculator. The Employment Ordinance is the sole authority for the law it explains; check the Labour Department’s guidance or a qualified adviser for your situation.