Home

›

›

Weekly Timesheet Template for Excel

,

Weekly Timesheet Template for Excel

This weekly timesheet template for Excel records time in, time out and break minutes for each day. Hours worked, regular and overtime hours, and regular, overtime and total pay calculate automatically from the hourly rate and your overtime rule, and the sheet has space for the employee’s and approver’s signatures.

We only use your email to send you this link. Privacy

Format
Excel, Google Sheets
Opens in
Excel, Google Sheets, LibreOffice and Numbers
Topic
HR
Publisher
ProTemplates
Price
Free
Weekly timesheet hours overtime pay

What’s inside

  • Seven days with dates filled in from the week start
  • Time in, time out and break minutes per day
  • Total, regular and overtime hours
  • Regular pay, overtime pay and total pay
  • Signature and approval lines

How to use it

  1. Enter the employee, week start, hourly rate and overtime rules.
  2. Fill in times and breaks for each day worked.
  3. Check the totals and pay.
  4. Print or save as PDF for signature.

FAQ

Does it handle shifts past midnight?

Yes. A shift that ends after midnight is counted as running into the next day.

Is overtime calculated daily or weekly?

Weekly, above the number of hours you set. If your rules use daily overtime, adjust the formula or ask your payroll provider.

Can I use it for contractors?

Yes. Set the overtime threshold high enough that it never triggers.