ReceiptKitReceiptKit / Free tools / Timesheet template
Timesheet Template
Choose a weekly or two-week sheet, add the employee and company names, the hourly rate and the overtime rule, and download an Excel timesheet that works out daily hours, overtime and gross pay from start, end and break times. A printable Word version is included too. No signup, no watermark.
Updated · Sources re-checked by
The Excel file calculates the hours, overtime and pay. It also opens in Google Sheets. Nothing you type is saved or sent anywhere.
How the timesheet works
Hours for a day = (end time − start time, rolled over midnight if the end is earlier) × 24 − break minutes ÷ 60, never below zero. Total hours = the sum of the days. Regular hours = the smaller of total hours and the overtime limit. Overtime hours = total hours above the limit. Regular pay = regular hours × the hourly rate. Overtime pay = overtime hours × the rate × the overtime multiplier. Gross pay = regular pay + overtime pay, before tax. The limit and the multiplier are cells you can change.
| Start | End | Break | Hours |
|---|---|---|---|
| 8:00 AM | 4:30 PM | 30 min | 8.00 |
| 7:00 AM | 3:00 PM | 0 min | 8.00 |
| 9:30 AM | 6:00 PM | 60 min | 7.50 |
| 10:00 PM | 6:00 AM | 30 min | 7.50 |
| File | Best for | Calculates? |
|---|---|---|
| Excel (.xlsx) | Typing times and getting hours, overtime and pay | Yes |
| Word (.docx) | Printing a blank sheet to fill in by hand | No |
| Team payroll calculator on this site | The cost of the whole team for a pay period | Yes |
Worked example: a 5-day week at $20 an hour
- Type 8:00 AM, 4:30 PM and 30 for the break on each weekday. Each row shows 8.00 hours.
- Total hours: 5 × 8 = 40. Regular hours 40, overtime hours 0.
- Regular pay: 40 × $20 = $800.00. Overtime pay: $0.00.
- If one day runs to 6:30 PM, total hours become 42, with 2 overtime hours at $20 × 1.5 = $60.00, so gross pay is $860.00.
Common questions
What should a timesheet include?
The employee's name, the week or pay period, the date and the start and end time of each day, any unpaid break, total hours, and a signature. Overtime and pay lines help with payroll.
How does the Excel timesheet work out hours?
It subtracts the start time from the end time, takes off the break and shows decimal hours, so 8 hours 30 minutes minus a 30 minute break is 8.00. Overnight shifts are handled.
How do I type times in Excel?
Type a time such as 8:00 AM or 17:30. The cell understands it as a time. If a cell shows a number such as 0.35, change its format to Time.
Can I use it for two weeks?
Yes. Choose the two-week sheet before you download. The totals add up all fourteen days, and you can change the overtime limit to match, for example 80 hours.
Does the sheet calculate overtime?
Yes, above the limit you set, 40 hours by default, at the multiplier you set, 1.5 by default. Change both cells if your rules differ.
Is a timesheet a legal record?
A signed timesheet is a useful record of hours worked, but rules about keeping time records differ by place, so check what applies to you.
More invoice tools
- Invoice Generator: Free invoice maker: items, tax, discount, deposit and balance due, with a clean PDF and no watermark.
- Contractor Invoice Template: Contractor invoice with job site, license number, labor, materials, deposit and balance due, as a clean PDF.
- Construction Invoice Template: Construction invoice for progress billing with project details, retainage held back and payments received.
- Freelance Invoice Template: Freelance invoice by the hour or a fixed fee, with expenses, an advance already paid and your currency.
- Blank Invoice Template: A blank invoice to print and fill in by hand, or fill online and let the totals work themselves out.
- Simple Invoice Template: A plain invoice in about a minute: your name, the client, items and one tax rate, as a clean PDF.
- Service Invoice Template: Service invoice with the service date and place, parts and fees, tax and payments, as a clean PDF.
- Trucking Invoice Template: Trucking invoice with a load sheet: route, miles, rate per mile, fuel surcharge and detention, as a PDF.
- Towing Invoice Template: Towing invoice built call by call: vehicle, call-out, extra miles, after-hours surcharge and storage days.
- Moving Company Invoice Template: Moving invoice that starts with a crew calculator: movers, hours, minimum hours, truck fee, boxes and stairs.
- Auto Repair Invoice Template: Auto repair invoice with a vehicle card, a parts table with part numbers, a labor table in hours and shop supplies.
- Roofing Invoice Template: Roofing invoice that measures first: footprint and pitch give squares, then install, tear-off and flashing are priced.
- Painter Invoice Template: Painting invoice built room by room: walls, ceilings, coats, gallons of paint and a price per square foot.
- Cleaning Service Invoice Template: Cleaning invoice priced by home size and add-on tasks, with a schedule that sets the repeat-visit discount.
- Free Estimate Template: Free estimate template with items, a contingency, a likely range around the total, a validity period and an acceptance signature.
- Quote Template Generator: Quote generator with a fixed price, tax, a payment schedule that adds up exactly, a validity period and an acceptance signature.
- Work Order Template: Work order template with priority, site, assignee, a task checklist, labor and materials, and a customer sign-off.
- Receipt Template Generator: Receipt generator with the payment method, date paid, amount received and balance remaining, as a clean PDF.
- Change Order Template: Change order with added work, credits for removed work, the revised contract total, the schedule change and a client signature line.
- Deposit Invoice Template: Deposit invoice that starts from the contract total: a percent or a fixed deposit, what was received and what is still due.
- Progress Invoice Template: Progress invoice built from a schedule of values: percent done before and this period, and what is billed now.
- Landscaping and Lawn Care Invoice Template: Landscaping and lawn care invoice from a service menu priced per visit, with a period total and a season total.
- Free Invoice Template: Free invoice template: set your details and download Word or Excel, opens in Google Docs and Sheets too.
- Invoice Template for Word: Free Word invoice template (.docx): choose rows, tax and extras, then edit every word in Word.
- Invoice Template for Excel: Free Excel invoice template (.xlsx) with formulas for amounts, tax, total and balance due.
- Invoice Template for Google Docs: Use the free invoice template in Google Docs or Google Sheets: download, upload to Drive, open and edit.
More calculators
- Concrete Calculator: Cubic yards, cubic meters and 40, 50, 60 and 80 lb bags for slabs and round columns, with waste.
- Concrete Slab Calculator: Concrete, bags and gravel base for one slab, with thickness presets and common size tables.
- Concrete Bag Calculator: How many 40, 50, 60 or 80 lb bags for a slab or fence posts, with total weight.
- Cubic Yard Calculator: Cubic yards for soil, mulch, gravel and more: several shapes, conversions, loads and bags.
- Gravel Calculator: Cubic yards and tons of gravel for driveways, paths and bases, with layers, loads and cost.
- Stair Calculator: Number of steps, exact riser, tread run, angle and slope length from the total rise, with a code check.
- Stair Stringer Calculator: Stair stringer layout: framing square numbers, bottom cut, throat depth, board length and stringer count.
- Roof Pitch Calculator: Convert rise over 12, degrees and percent slope, and get slope factor, rafter length and ridge height.
- Board Foot Calculator: Board feet for several boards at once, with quarter notation, cost, cubic feet and cubic meters.
- Paver Calculator: Number of pavers, pallets, gravel base, bedding sand and edge restraint for a patio, path or driveway.
- Square Footage Calculator: Add rooms and shapes in feet, inches or meters, subtract cutouts, and see sq ft, sq yd, m² and acres.
- Paint Calculator: Gallons of paint room by room: walls, doors, windows, ceiling and coats, with the amount to buy.
- Paint Calculator by Square Feet: Gallons of paint from a square footage: coats, coverage, waste, quarts to buy and cost per square foot.
- Mulch Calculator: Cubic yards for delivery and bags from the store for several beds, with a cost for each way.
- Drywall Calculator: Sheets of drywall, boxes of joint compound and screws for rooms with doors, windows and ceilings.
- Markup Calculator: Markup vs margin: enter a cost and a markup, a margin or a price, and see the other two and the profit.
- Profit Margin Calculator: Gross and net profit and margin for a job or a month, and the price that reaches a target margin.
- Contractor Hourly Rate Calculator: The hourly rate to charge from your wanted pay, tax estimate, overhead, profit cushion and billable hours.
- Labor Cost Calculator: True labor cost for a crew: wages, overtime and burden, the cost per hour and a bill-out price.
- Fence Calculator: Posts, panels or pickets and rails, post length and bags of concrete for runs of fence with gates.
- Roofing Calculator: Roof sections with pitch to squares, shingle bundles with waste, underlayment rolls, drip edge and cost.
- Roof Square Calculator: Square feet to roofing squares from an area, a flat plane or a footprint with pitch, with bundles and a price.
- Wallpaper Calculator: Wallpaper rolls by the drop method: strips per wall, pattern repeat, strips per roll and rolls to order.
- Insulation Calculator: Depth for a target R-value from the R per inch on your label, with volume, existing layer and packages.
- Plywood Calculator: Sheets of plywood for floors, walls and roofs from areas with openings taken away, by sheet size, with cost.
- Team Payroll Calculator: Employer cost of a team of 10 to 50 workers: hourly and salaried, overtime, burden, cost per period and per year.
- Overtime Calculator: Overtime pay at 1.5x or your own multiplier, double time, and the effective hourly rate.
- Hourly to Salary Calculator: Hourly rate to yearly, monthly, weekly and daily pay, and salary back to hourly, with unpaid weeks.
- Feet and Inches Calculator: Add, subtract, multiply and divide lengths in feet and inches, find how many pieces fit, and total a list of measurements.
Sources
- Office Open XML (.docx and .xlsx): the file formats Word, Excel, Google Docs and Google Sheets all read (checked October 28, 2026)
This template is a layout for your records. It is not payroll, tax or legal advice. Overtime and record-keeping rules differ by place, so check the rules that apply to you.