No email gate · Excel and Google Sheets compatible
Free Timesheet Templates
Download a practical weekly or biweekly timesheet with daily clock times, unpaid breaks, decimal hours, weekly overtime and estimated gross pay.
7-day workweek
Weekly Timesheet Template
One week with daily start, end and unpaid-break entries. Automatically totals worked hours, regular hours, overtime and estimated pay.
- Employee, week, job and site fields
- Daily decimal hours and weekly total
- Editable overtime threshold and multiplier
14-day pay period
Biweekly Timesheet Template
Two separate seven-day weeks. Each week applies its own overtime threshold, so hours are not incorrectly averaged across the pay period.
- Fourteen daily time-entry rows
- Separate Week 1 and Week 2 overtime
- Pay-period totals and estimated gross pay
What is included
Both templates contain clearly color-coded input and formula areas, instructions and example settings. Enter clock-in and clock-out values as spreadsheet times, enter unpaid breaks in minutes and set an hourly rate only if you want a pay estimate.
How the formulas work
Each day subtracts the start time and unpaid break from the end time. If the shift crosses midnight, the formula rolls the end into the following day. Weekly overtime is the portion of weekly hours above the editable threshold.
Use in Google Sheets
- Download the Excel file.
- In Google Drive, choose New → File upload.
- Open the uploaded workbook with Google Sheets.
Spreadsheet applications can display time and formulas slightly differently. Check the totals before relying on the file for payroll.
Frequently asked questions
Do I need to provide an email address?
No. Both files are direct downloads and do not require an account or email address.
Are the templates payroll software?
No. They organize entries and estimate totals. They do not apply every employment rule, tax, deduction or payroll policy.
Can I change the overtime threshold?
Yes. Both templates include an editable weekly threshold and multiplier. In the biweekly workbook, overtime is still calculated separately for each week.