An English Excel (XLSX) workbook for small teams to record shifts per person, deduct unpaid breaks and review net hours for a chosen period. Includes a BLANK workbook, a DEMO workbook with fictional examples and a 3-page PDF quick-start guide. One-time digital download.

The problem it solves

Shift times, breaks and night shifts end up on paper, in chats or in scattered files, and totals per person are slow to check.

Who it is for

Small teams and managers, for example cleaning or hospitality staff, who want a simple spreadsheet to record who worked when, without payroll software.

What you get

• Record up to 20 people and 500 shifts with explicit start and end date-times, including shifts that cross midnight
• Gross hours, unpaid break hours and net hours per person for any period you choose on the Overview sheet
• Whole-shift rule: an overnight shift is counted entirely on its start date and is not split across days, months or years
• Flags for missing or duplicate IDs, unknown team members, invalid dates, over-24-hour shifts, bad breaks and overlapping shifts
• A BLANK workbook for your own records and a DEMO workbook with fictional examples to explore first

How you use it

1. Download and extract the whole ZIP, open BLANK in desktop Microsoft Excel and save a working copy.
2. In Team, enter a unique Team ID and a name or reference for each person.
3. In Shifts, record each shift with a unique Shift ID, Team ID, start and end date-time, unpaid break minutes and status.
4. In Overview, choose the start and end dates, fix any flags, then review the hours per person.
5. Use File > Save As to keep dated XLSX backups.

Questions