Download a free timesheet template to print and fill in by hand, or use the Excel version that totals your hours for you. Each template has the same columns: time in, lunch out, lunch in, time out, other unpaid breaks, hours worked (H:MM) and decimal hours, with signature lines for the employee and supervisor. No sign-up or email needed.
| Template | Format | Best for | Download |
|---|---|---|---|
| Weekly timesheet | PDF (US Letter, landscape) | One week of clock-in and clock-out times | Download PDF |
| Biweekly timesheet | PDF (US Letter, landscape) | A 14-day pay period with a total for each week | Download PDF |
| Biweekly timesheet with overtime | Excel (.xlsx) | Daily, weekly and pay-period totals, weekly overtime and estimated gross pay calculated for you | Download Excel |
How to Fill In a Timesheet
- Write the employee name, ID and pay period at the top.
- For each day, write the time in, the time you left for lunch, the time you came back and the time out.
- Write any other unpaid break in minutes.
- Work out each day: (lunch out − time in) + (time out − lunch in) − other unpaid breaks.
- Add the days together in hours and minutes, then convert the total to decimal hours.
- Sign and date the timesheet, and ask your supervisor to sign it.
Example: 8:00 AM to 12:00 PM is 4:00 and 12:30 PM to 4:30 PM is 4:00, so the day is 8:00 (8.00 decimal hours). Minutes are not decimals: 7 hours 45 minutes is 7.75 hours, not 7.45. The minutes to decimal hours chart lists every minute.
Excel Timesheet With Automatic Totals
The Excel template does the arithmetic. Type times such as 8:00 AM or 16:30 in the yellow cells, and it shows:
- each day’s hours in H:MM and decimal hours
- a total for each week and for the pay period
- regular and overtime hours, using the weekly overtime threshold you set (for example, over 40 hours)
- estimated gross pay before tax, if you add an hourly rate and overtime multiplier
A time out earlier than the time in is read as a shift that ran past midnight. The template applies one weekly overtime rule; for daily overtime as well, use the online Timesheet below.
Prefer Not to Do the Math?
The Timesheet in the Work Hours Calculator does all of this in your browser: 7-day, 14-day or custom pay periods, several work periods a day, daily and weekly overtime rules, a printable timesheet with signature lines, and CSV export. To turn overtime hours into pay, use the Overtime Calculator.
Frequently Asked Questions
Are these timesheet templates free?
Yes. Download, print and share them. No sign-up or email is needed.
Can I use a template for a two-week pay period?
Yes. The biweekly PDF and the Excel file both cover 14 days, with a total for each week and for the whole pay period.
How do I convert minutes to decimal hours on a timesheet?
Divide the minutes by 60. 15 minutes is 0.25, 30 minutes is 0.50 and 45 minutes is 0.75 hours.
Does the Excel template work in Google Sheets?
Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas use standard spreadsheet functions.
Related Calculators
- Work Hours Calculator — weekly time card and timesheet with overtime rules.
- Hours Calculator — time between two times, and add or subtract hours and minutes.
- Overtime Calculator — overtime pay at time and a half, double time or a custom rate.
- Time to Decimal Calculator — convert hours and minutes to decimal hours.