Timesheet template for Excel

A weekly timesheet that turns clock-in and clock-out times into hours and pay. Enter the start and finish time and unpaid break for each day; it works out daily hours, splits the week into regular and overtime hours at the threshold you set, and multiplies by the hourly rate and overtime multiplier. There is space for employee and manager signatures at the bottom.

Templates

Weekly timesheet (Excel spreadsheet): A weekly timesheet template: start, finish and break times give daily hours, regular and overtime hours, and total pay.
Work schedule (staff rota) (Excel spreadsheet): A weekly employee work schedule and staff rota: pick a shift per person per day, colour-coded, with hours per person and staff per shift.
Employee attendance sheet (Excel spreadsheet): A monthly employee attendance sheet in Excel: mark present, absent, leave, half day or holiday, with automatic totals and attendance %.

How to use these templates

Fill in the employee, manager, week starting date and hourly rate. Dates for each day follow from the week start.
Type start and finish times like 9:00 AM and 5:30 PM, and the unpaid break in hours, such as 0.5 for thirty minutes.
Set when overtime starts (40 hours a week is common in the US) and the overtime multiplier, such as 1.5 for time and a half.
Print or save as PDF, sign, and send it for approval.

Timesheet tips for employees and managers

Enter times as you would read them on a clock, with AM or PM. Excel stores them as fractions of a day, and the sheet converts the difference to hours.
Record breaks separately rather than shortening the finish time, so the record shows when people were actually on site.
Overtime rules differ by place: US federal law uses 40 hours a week, some states also count daily overtime, and UK contracts set their own terms. Adjust the threshold to match.
Keep signed copies. Employers in many countries must keep working-time records for several years.
Shifts that cross midnight need the finish time on the next day; split them into two rows, one before and one after midnight.

Frequently asked questions

How do I calculate hours worked in Excel?

Subtract the start time from the finish time and multiply by 24 to turn the fraction of a day into hours, then subtract the break. The Hours column uses exactly that formula.

Can I use it for a two-week pay period?

Download it twice into one workbook, one sheet per week, and add the two Total pay cells together.

Is there a version for scheduling shifts in advance?

Yes. The work schedule (staff rota) template plans who works which shift each day and totals the hours.

Does it work for salaried staff?

Yes for tracking hours; set the hourly rate to zero if you only need the time record.