InvoiceTools

Timesheet and time card calculator

Free timesheet calculator

Put in clock in, clock out and lunch break for each day and the hours add up for you: five days at 8am to 4pm with a 30 minute lunch comes to 37.50 hours.

  • Free timesheet calculator
  • Hours worked out from the clock
  • Overtime split out
  • Nothing leaves your browser
Timesheet
100%
Click any text on the document to edit itLetter or A4 · Portrait
TIMESHEET

Powered by InvoiceTools.com

How to calculate hours worked with a lunch break

Built for the people who actually fill these in at the end of a week, on a phone, in a van. Put the start, the end and the break in, and the hours are worked out for you, because adding up decimal hours in your head at 6pm on a Friday is how the arguments start. If you want to check a day by hand, it is four steps:

  1. Write down the clock in time, for example 7:30.
  2. Write down the clock out time, for example 16:15. That is 8 hours 45 minutes on site.
  3. Take off the unpaid lunch break. With 30 minutes for lunch, 8 hours 45 minutes becomes 8 hours 15 minutes.
  4. Turn the minutes into a decimal by dividing them by 60. 15 minutes is 0.25, so the day is 8.25 hours.
Minutes to decimal hours
MinutesDecimal hours
50.08
100.17
150.25
200.33
300.50
400.67
450.75
500.83

Most timesheet disputes are arithmetic, not dishonesty. Somebody works 7:30 to 16:15 with a 45 minute break and writes down 8 hours because that is roughly what it felt like. Do that five times and the week is out by nearly an hour.

Putting the clock times in and letting the page do the subtraction removes that entirely. An end time earlier than the start is read as an overnight shift rather than rejected as a typo, because night shifts are real and a form that will not accept them is a form people work around.

Turn a timesheet into an invoice

If you are the one billing, the button under the sheet carries each day across to the invoice generator as its own line, with the hours as the quantity and the rate as the unit price. The client sees the days, not one lump labeled labor. To price the hours before the week starts, the hourly invoice calculator and the billable hours calculator do the sums.

The sheet a worker hands to a payroll clerk usually should not carry rates. The sheet a contractor keeps in order to bill the client has to. That is one control on this page rather than two different documents, and it changes what prints.

Weekly overtime past 40 hours

Anything past 40 hours in the week is split out as overtime, so the sheet shows which hours were at which rate rather than one total that has to be taken on trust. A single total with overtime already mixed into it is a number nobody can check.

The threshold is weekly, not daily. By default the sheet counts hours past 40 for the whole week and adds the overtime at 1.5 times the rate, which suits most arrangements in the United States; change either figure in the overtime fields. It does not apply a daily limit such as overtime after 8 hours in a day, so if your arrangement pays that way, work those hours out separately. Overtime after and Overtime rate take a weekly threshold and a multiplier, the sums use them, and both print on the sheet so the person approving it can see what was agreed.

Biweekly timesheet

A biweekly timesheet covers two weeks, which is how many employers run payroll: one pay period, paid every other week. This page does one week per sheet, so for a biweekly period make a sheet for each week and keep them together. Overtime is counted per sheet, past 40 hours for that week, which matches how weekly overtime is usually measured even when pay goes out every two weeks.

Decimal hours

Payroll and invoices usually want hours as decimals rather than hours and minutes. Convert the minutes by dividing by 60 and add them to the whole hours: 7 hours 45 minutes is 7 + 45/60, or 7.75 decimal hours. The table above covers the common quarter-hour and five-minute steps. The sheet works from clock times and shows each day in decimal hours, so you do not need to convert by hand.

Timesheet or time card?

They are the same record under two names. Time card is the older name, from the cards that went into a punch clock; timesheet is the usual word now, especially once the hours are typed rather than stamped. This page works as a time card calculator too: the clock times go in and the weekly total comes out.

Questions people ask

What is a timesheet calculator?

A timesheet calculator adds up hours worked from the times you put in, rather than leaving you to total decimal hours by hand. This one also prints the finished sheet. A timesheet is a record of hours worked, usually over one week, broken down by day and by what the time was spent on. It is what an employer or a client approves before the hours are paid or invoiced.

Does this work out the hours for me?

Yes. Put in the start time, the end time and any unpaid break, and the hours for that day are calculated. Five days of 8am to 4pm with a 30 minute break comes to 37.50 hours.

Can I record a night shift?

Yes. An end time earlier than the start time is treated as running past midnight rather than as a mistake, so a 22:00 to 06:00 shift records as 8 hours.

How is overtime calculated?

Hours past 40 in the week (or the threshold you set) are shown separately, and the overtime is added at 1.5 times the rate unless you set another. The threshold is weekly, not daily. Type a different weekly threshold in Overtime after, or a different multiplier in Overtime rate, and the sums use it.

Can I hide the pay rates?

Yes, with one control. The copy going to a payroll clerk usually should not show rates, and the copy you keep in order to invoice a client has to. Same sheet, one switch.

Can I turn a timesheet into an invoice?

Yes. The button under the sheet carries each day onto the invoice generator as its own line, with the hours as the quantity and the rate as the unit price, so the client sees the days rather than one lump labeled labor.

Does a timesheet need to be signed?

For most payroll and most clients, yes. An unsigned timesheet is a claim; a signed one is an approval. Sign by typing the name or drawing it with a finger.

How long should I keep timesheets?

Record-keeping periods vary by country and by state, and several years is common. Keep the PDFs somewhere they can be found, and check the requirement that applies where you work rather than assuming.

Can I use this for more than one worker?

One sheet covers one person for one week, which is how most payroll and most clients want it. For a crew, make one sheet each rather than mixing people on a single page, because a mixed sheet cannot be approved by one signature.

How do I save a timesheet as a PDF?

Use Print or save PDF and choose Save as PDF as the destination in your own print dialog. The sheet is scaled to one page first, so it does not split.

How do I convert minutes to decimal hours?

Divide the minutes by 60. 15 minutes is 0.25, 30 minutes is 0.50 and 45 minutes is 0.75, so 7 hours 45 minutes is 7.75 hours. The calculator does this for you from the clock times.

Is a timesheet the same as a time card?

Yes, for most purposes. Time card is the older name from punch clocks and timesheet is the usual one now. Both record when each day started and ended and the hours in between, so this works as a time card calculator as well.

Can I fill in two weeks on one sheet?

One sheet covers one week. Overtime is counted past 40 hours for the whole sheet, so two weeks on one sheet would show overtime nobody worked. For a two week pay period, make one sheet for each week.

Is a lunch break paid?

It depends on your agreement and on the rules where you work, so check those rather than assuming. On this sheet, put only the unpaid part of the break in the break column. A paid break stays in the hours.

Can an employer change a signed timesheet?

Corrections happen, but a change to hours that were already signed should be agreed and signed again rather than made quietly. Keep a PDF of each signed sheet so there is a copy of what was approved, and check the rules where you work if you think hours were changed without your agreement.

Need a different document?

Free and in your browser, like this one: Invoice generator · Work order generator · Quote generator.

Send it yourself, or send it and watch it

Everything here is free. Generators, calculators and downloads need no account. Send a document as a link instead and you see when it was opened, which line they questioned, and who signed it, so chasing becomes a decision rather than a guess.

The first four documents you send as a tracked link are free with an account. Everything else on InvoiceTools.com stays free. Generators, calculators and downloads need no account; template designs need a free one.