Timesheet Calculator

Free weekly timesheet template

Use this as a weekly time sheet: one row per shift, an unpaid lunch column, a 40-hour overtime cutoff you can change, and an optional hourly rate. Calculate on the page and download a CSV for your records or for payroll.

Hours worked

Monday through Friday, 9am to 5pm, with a 30 minute lunch, is filled in. Change any cell. An end time on the next morning, such as 10pm to 6am, counts through midnight.

The hours you type here are used for this calculation and are not stored.

Columns on a clear timesheet

ColumnWhat to enter
DayWeekday or date, such as Mon or 2026-11-09
StartClock-in time (9am, 09:00, or 9:00 AM)
EndClock-out time. For an overnight shift, use the next morning, such as 6:30am
Unpaid breakLunch or other unpaid minutes. Use 0 if you already clocked out for the meal
HoursCalculated: elapsed time minus the break, in hours:minutes and decimal hours
Week totalSum of the rows, split into regular and overtime

Sample week already filled in

The form above starts with Monday through Friday, 9:00 a.m. to 5:00 p.m., and a 30-minute lunch. That is 7.5 hours a day and 37.5 hours for the week. Change Friday to 5:30 p.m. and the week becomes 38 hours. Add a Saturday 9:00–1:00 and you cross 40 hours, and overtime appears if you leave the weekly cutoff at 40.

Need a paper-style layout? Calculate the week, download the CSV, and print it from Excel or Google Sheets. Nothing you type is stored here.

Tips for a timesheet that payroll can use

Related: how to calculate hours worked, lunch breaks, and the time card calculator.

Questions people ask

What should a weekly timesheet include?

At a minimum: the worker's name or day label, date or weekday, clock-in, clock-out, unpaid break, hours worked that day, and a week total. Add overtime and gross pay if you use an hourly rate.

Can I download a timesheet as a CSV?

Yes. Fill in the calculator, check “Include a CSV,” and calculate. You can open the file in Excel or Google Sheets. The shift list is not stored on this site.

Is this timesheet template free?

Yes. You can use the calculator and download a CSV without creating an account.

Get updates and a weekly reminder

Leave an email for product updates and an occasional nudge to write down your hours. We store only the address and the page you used, never the shifts from the calculator. Remove it any time by emailing us.