Free weekly & biweekly timesheet templates

Download a timesheet

Excel files calculate hours from your entries. PDFs are blank A4 sheets for printing and completing by hand. All downloads are free, with no signup.

Weekly: 7 days

Biweekly: 14 days

The blank CSV has no formulas. You can also print the weekly sheet below.

Choose a format for your record

The weekly Excel workbook calculates seven days; the biweekly workbook calculates 14 days with a separate total for each week. Both keep start time, end time and unpaid breaks visible alongside net minutes, hours and minutes, and decimal hours.

Use a printable PDF if you want to write in your hours by hand. The blank weekly CSV is a simple recording sheet without formulas. To calculate several shifts on the same day, use the online timecard calculator and export the completed record.

Record the pieces separately

The Excel templates have one shift per day. Enter the start and end times, then unpaid break minutes as a whole number. Set Next day to 1 when the end is the following day, or 0 for the same day. Leave unused days blank and correct any row marked invalid before using the totals.

For a day from 09:00 to 17:30 with a 30-minute unpaid lunch, enter 0 for Next day and 30 for break minutes. The net result is 480 minutes, 8:00 in hours and minutes, or 8.00 decimal hours. Five identical days total 40 hours.

Check an overnight shift

For 22:00–06:00 with a 30-minute unpaid break, select 1 for Next day. Eight clock hours minus the break gives 450 minutes, 7:30 in hours and minutes, or 7.50 decimal hours. The template assigns those hours to the row on which you enter the shift.

The formulas use entered clock times. They do not adjust for daylight-saving changes or time zones. A single row covers at most 24 hours; use separate records for longer periods or multiple shifts in one day.

Keep worked hours separate from payroll rules

These workbooks calculate exact work hours after entered unpaid breaks. They do not calculate overtime pay, taxes or shift rounding. The biweekly workbook keeps each week's hours visible rather than deciding how either week should be paid.

Review blank days, next-day choices and breaks before printing or sharing a copy. Keep your original entries and any applicable overtime or rounding policy with your own records; the template does not set a payroll policy.

Use the Excel template in Google Sheets

1. Download the weekly or biweekly Excel file above.
2. Open Google Sheets and choose File → Import → Upload.
3. Select the downloaded XLSX and choose Create new spreadsheet.
4. Enter clock times in the yellow cells, such as 09:00 and 17:30. Use 1 in the Next day column for an overnight shift, or 0 for a same-day end. Enter unpaid breaks in whole minutes.

Check your first entry against a known example: 09:00 to 17:30 with a 30-minute unpaid break should show 8:00 and 8.00 hours. The grey cells contain formulas. For more than one shift in a day, use the timecard calculator with multiple shifts.