Employee Calculators
Time card calculator
Work time

Timesheet Calculator

Fill in a one- or two-week timesheet the way a paper timesheet works: time in, lunch out, lunch in, and time out for each date. The timesheet calculator totals each day and week, applies overtime per workweek, estimates gross pay, and exports to CSV.

Runs in your browserFree, no signupFormula shown below
Use the first day of your workweek.
Pay period
Printed on the summary only.

Timesheet, Oct 5 to Oct 18

Week 1Oct 5 to Oct 11

40.00 h
MonOct 58h8.00 h
TueOct 68h8.00 h
WedOct 78h8.00 h
ThuOct 88h8.00 h
FriOct 98h8.00 h
SatOct 100h0.00 h
SunOct 110h0.00 h

Week 2Oct 12 to Oct 18

42.00 h incl. 2.00 h overtime
MonOct 128h8.00 h
TueOct 138h8.00 h
WedOct 1410h10.00 h
ThuOct 158h8.00 h
FriOct 168h8.00 h
SatOct 170h0.00 h
SunOct 180h0.00 h
Pay, overtime, and rounding

Timesheet totals

Total hours
82.0082h
Regular hours
80.0080h
Overtime hours
2.00Counted per workweek
Estimated gross pay
$1,660.00$1,600.00 + $60.00 overtime
Hours by day
Hours by day
Mo8.0 (Regular: 8)
Tu8.0 (Regular: 8)
We8.0 (Regular: 8)
Th8.0 (Regular: 8)
Fr8.0 (Regular: 8)
Sa ()
Su ()
Mo8.0 (Regular: 8)
Tu8.0 (Regular: 8)
We10.0 (Regular: 10)
Th8.0 (Regular: 8)
Fr8.0 (Regular: 6, Overtime: 2)
Sa ()
Su ()

Lunch time recorded: 5h (not counted as worked time). Gross pay is before taxes and deductions.

Timesheet Calculator, printed from employeecalculators.com/timesheet-calculator/. Estimates of gross amounts before taxes and deductions, based on the values entered; not payroll or legal advice.

How the timesheet calculator works

  1. Set the first day of the timesheet, normally the first day of your workweek, and choose one or two weeks.
  2. Enter four punches per day. Leave the lunch fields blank on days without a lunch break. Use "Copy down" to repeat a day's times on the next day.
  3. Open pay, overtime, and rounding to add your hourly rate, the weekly overtime limit, the multiplier, and optional punch rounding.
  4. Review the totals and chart, then download a CSV, copy a summary, or print.

Timesheet formula

Daily hours = (lunch out − time in) + (time out − lunch in)Without lunch punches: time out − time in. Each block that ends earlier on the clock than it starts is treated as ending the next day.
Weekly overtime = max(0, weekly hours − weekly limit), for each week separately
Gross pay = regular hours × rate + overtime hours × rate × multiplier

Worked example: a two-week timesheet

8:00 AM to 4:30 PM with a 30-minute lunch, one late night to 6:30 PM in week 1, $20.00 an hour

  1. A normal day: 4 hours before lunch plus 4 hours after = 8 hours.
  2. Week 1 has one 10-hour day, so it totals 42.00 hours, with 2.00 hours of overtime.
  3. Week 2 totals 40.00 hours with no overtime.
  4. Two-week total: 82.00 hours (82h).
  5. Gross pay: $1,600.00 regular + $60.00 overtime = $1,660.00 before taxes.

Overtime on two-week timesheets

A two-week pay period is still two separate workweeks for federal overtime. The Department of Labor states that hours cannot be averaged across two or more weeks. In the example above, the two weeks total 82 hours. If averaged, only 2 hours would be over 80. Counted correctly, week 1 has 2 hours over 40, and week 2 has none. With a 48-hour week followed by a 32-hour week, averaging would show no overtime at all, while the correct answer is 8 hours.

The biweekly pay calculator shows this effect with weekly totals only.

Related reading: how overtime pay is calculated and how to calculate lunch breaks on a time card.

Assumptions

  • Each group of seven days, starting on the date you choose, is one workweek.
  • Lunch is unpaid because you punched out. Paid breaks should not be punched out.
  • Rounding, if selected, applies to every punch to the nearest 5, 6, or 15 minutes.
  • Pay uses one hourly rate and is before taxes and deductions. Daily overtime rules are not applied; use the time card calculator for those.

Frequently asked questions

What is the difference between a timesheet and a time card?

They are often used interchangeably. Here, the timesheet calculator uses four punches per day (in, lunch out, lunch in, out) across one or two weeks with dates and CSV export. The time card calculator uses one or more shifts per day with a break deduction for a single week.

How is overtime calculated on a two-week timesheet?

Week by week. Each seven-day week is totaled on its own, and hours over your weekly limit in that week are overtime. Under the federal FLSA, hours are not averaged across two weeks, so 48 hours plus 32 hours gives 8 overtime hours, not zero.

What if I did not take a lunch?

Leave both lunch fields blank. The day is then counted from time in to time out. If only one lunch punch is filled in, the day is flagged until both are entered or both are blank.

Can I open the CSV in Excel or Google Sheets?

Yes. Download CSV creates a standard comma-separated file with the date, punches, decimal hours, and regular and overtime hours for each day, plus totals.

Is my timesheet saved?

Only if you choose. Nothing is ever sent to a server. Turn on "Remember on this device" to keep your entries in this browser, and "Forget saved entries" removes them. To keep a history of many weeks, use the weekly pay tracker.

Related guides

How to Calculate Lunch Breaks on a Time CardTwo ways to take lunch off a time card: lunch punches or a fixed deduction. Worked examples, paid vs unpaid breaks under federal rules, and common mistakes.What Is a Workweek for Overtime?The FLSA workweek is a fixed 168-hour period that can start on any day and hour. Why each week stands alone for overtime and how the start day matters.How to Track Your Work Hours (and Why It Pays Off)How to track your work hours accurately: what to record for each shift, simple methods from paper to spreadsheets, weekly totals, and overtime.How to Calculate a Time Card, Step by StepCalculate a weekly time card by hand: daily hours, lunch, rounding, the weekly total, overtime, and gross pay. A full worked example you can check.
Time Card CalculatorTotal a week of shifts, subtract unpaid breaks, and split regular from overtime hours.Biweekly Pay CalculatorTwo-week gross pay with overtime counted separately for each workweek.Overtime CalculatorPrice overtime and double-time hours with your own rate and multipliers.Gross Pay CalculatorGross pay for a pay period from hours or salary, overtime, tips, bonuses, and other earnings.

How this calculator was built. The formula, defaults, and edge cases are documented in a research record and covered by automated tests. It estimates gross amounts from your inputs; it does not determine legal entitlements, taxes, or take-home pay. Read our methodology and disclaimer.

Last updated:

Sources