Team Hours Tracker Spreadsheet, Weekly Payroll Hours for 15 Staff (XLSX)
By EducoPrice in USD. Local taxes calculated at checkout.
Buy 3 or more, save 20% from this shop
- 1 ZIP download · XLSX, TTF, TXT, ZIP formats · 3 tabs; XLSX
- Buyer protection. Corrupt or mismatched files? Full refund.
Item details
A weekly hours grid for up to 15 employees with rates, daily hours, overtime above 40 hours and gross pay.
'Weekly Hours' has 15 rows; each takes a rate and daily hours for Mon, Tue, Wed, Thu, Fri, Sat, Sun, then calculates total, regular (up to 40 hours) and overtime hours and gross pay at 1.5× overtime. 'Cost Summary' links the first 12 rows and charts gross pay by employee.
Cells with overtime hours highlight amber; hour cells only accept numbers from 0 to 24.
Sheets arranged for this task: Weekly Hours: 15 employee rows × 7 days with total, regular and overtime hours, gross pay.; Cost Summary: Hours and gross pay per employee with a column chart..
8 employees named 'Employee 01'… with invented rates and hours are included as examples.
A single ZIP contains XLSX workbook, Montserrat, Andika OFL font files and licences, and README.txt. The Start Here tab explains inputs, calculations and how to clear the worked entries.
The workbook contains 107 formulas. Its soft lavender design uses coloured input cells and separate calculation cells. Install the bundled fonts before editing to match the previews.
Works with spreadsheet software supporting XLSX files. Digital download; no macros or external data connections.
File specs
| Formats | XLSX, TTF, TXT, ZIP |
|---|---|
| Dimensions | 3 tabs; XLSX |
| Color space | sRGB |
| Downloadable files | 1 ZIP download · XLSX, TTF, TXT, ZIP formats |
| Category | Templates |
| Last updated |
What you’ll download
- zipteam-hours-tracker-spreadsheet-weekly-payroll-hours-for-15-s.zip116 KB
License and usage
- Personal · $4.99
- Use the files in your own non-commercial projects: home prints, gifts, personal social posts and school work. Anything made with them can’t be sold.
- Commercial · $14.97
- Use the files in client work and in products you sell, up to 5,000 units across all products. Credit is appreciated but not required.
No license allows reselling, sharing or redistributing the original files as they are, including in free packs or AI training sets.
