United States · Weekly, biweekly, semi-monthly and monthly · Overtime per workweek

Timesheet calculator

A timesheet adds the hours worked each day into a total for each workweek. Hours over 40 in any one workweek are overtime, even when the pay period is two weeks or a month. In our example, 42:00 and 38:00 hours make 80:00 over two weeks, 2 hours of it overtime in week 1: $1,458.00 at $18 an hour.

Type the hours for each day of each workweek in your pay period. We total each week, mark the overtime and add up the pay. Nothing you type leaves your browser.

Hours each day as 8, 8.5 or 8:30. Each row is one workweek, Sunday to Saturday; leave days off empty.

Wk 1 42:00
Wk 2 38:00

Timesheet · 2 workweeks · Texas

80:00 hours

80.00 in decimal hours · 2 overtime · $1,458.00 before tax at $18.00 an hour

Hours and overtime for each workweek
WorkweekHoursRegularOvertimePay
Week 142:00402$774.00
Week 238:00380$684.00
Total80:00782$1,458.00
  • Texas follows the federal rule: time and a half for hours over 40 in a workweek, with no daily overtime.
  • Overtime is worked out for each workweek on its own, never averaged across the period (averaging would pay $1,440.00, $18.00 less).

How do I add up a timesheet?

  1. Hours for each day: write them as decimals (8.5) or hours and minutes (8:30). For a day of in and out times, the hours calculator works them out.
  2. Total each workweek: a workweek is a fixed run of seven days, the same every week (for example Sunday to Saturday).
  3. Overtime, week by week: hours over 40 in a workweek are paid at 1.5 times the rate. Never add two weeks together first.
  4. Pay: regular hours times the rate, plus overtime hours times 1.5 times the rate, for each week; then add the weeks in the period.

A worked example, by hand

A timesheet adds the hours worked each day into a total for each workweek. Hours over 40 in any one workweek are overtime, even when the pay period is two weeks or a month. In our example, 42:00 and 38:00 hours make 80:00 over two weeks, 2 hours of it overtime in week 1: $1,458.00 at $18 an hour.

  1. Week 1: 8 + 8 + 9.5 + 8 + 8.5 = 42.00 hours. That is 2 hours over 40: 40 hours × $18.00 = $720.00, plus 2 hours × $27.00 = $54.00. $774.00.
  2. Week 2: 8 + 8 + 8 + 8 + 6 = 38.00 hours, all regular: 38 hours × $18.00 = $684.00.
  3. The pay period: 80.00 hours and $1,458.00. Averaging the two weeks (80.00 hours is not over 80) would pay only $1,440.00: that is why each workweek is counted on its own.

The calculator above starts on this two-week timesheet.

What are weekly, biweekly, semi-monthly and monthly timesheets?

  • Weekly: one workweek, 52 paychecks a year.
  • Biweekly: two workweeks, 26 paychecks a year. The most common schedule for hourly work.
  • Semi-monthly: twice a month, 24 paychecks a year, often the 1st to the 15th and the 16th to the end of the month. A period does not line up with workweeks, so enter the days of each workweek that fall in it.
  • Monthly: 12 paychecks a year; a month touches four or five workweeks. Overtime is still counted week by week.

Whatever the pay period, federal law counts overtime by the workweek, and averaging hours over two or more weeks is not allowed (29 CFR 778.104). If a differential or a second rate applies to some hours, the regular rate for overtime is the week’s straight-time pay divided by all its hours (29 CFR 778.115): the time card calculator handles that.

What does this calculator leave out?

  • Tax: the pay shown is before tax. The time card calculator shows take-home pay in every state.
  • Shift differentials, bonuses and second rates, which change the regular rate for overtime.
  • Exempt jobs, alternative workweeks and industry rules; it is an estimate, not legal advice.

What else can I work out?

Questions about timesheets

How do I calculate a timesheet?

Write down the hours for each day, add them up for each workweek, then mark hours over 40 in any workweek as overtime. Multiply regular hours by your rate and overtime hours by 1.5 times your rate. Our two-week example comes to 80.00 hours and $1,458.00.

What is the difference between a biweekly and a semi-monthly timesheet?

Biweekly is every two weeks: 26 pay periods a year, always two full workweeks. Semi-monthly is twice a month (often the 1st to the 15th, then the rest of the month): 24 pay periods, which start on different weekdays, so a workweek can fall across two periods.

How is overtime worked out on a monthly timesheet?

Still by the workweek. Federal law counts overtime as hours over 40 in a fixed seven-day workweek, so a month is split into its workweeks first. A month can hold 160 hours with no overtime, or overtime in one heavy week.

Can I type hours and minutes?

Yes. Type 8:30 or 8.5 for eight and a half hours; both work, and 7:45 is the same as 7.75. Leave days off empty.

How do I open the CSV in Excel?

Download it, then open it in Excel, Google Sheets or Numbers: each week is a block of rows with the day, the hours and the week’s total and overtime.

Is my timesheet saved?

It stays in the address bar after “#”, so you can bookmark it or share the link; nothing is sent to us. For punches, breaks and saved weeks, use the time card calculator.