ShiftCalcs

Timesheet Calculator

Pick the pay period and its first day, then enter start and end times. Download the finished timesheet as a CSV file or print it.

$
Resultshiftcalcs.com

Enter a start and end time for at least one day.

How to use the timesheet

  1. Choose the length of your pay period. Two weeks is the most common in the United States.
  2. Pick the first day of the period so each row shows its date.
  3. Enter start time, end time and unpaid break minutes for each day worked.
  4. Press Download CSV to save a file that opens in Excel or Google Sheets, or press Print.

Overtime on a two week timesheet

Overtime is worked out one week at a time, not across the whole pay period. If you work 50 hours in week one and 30 in week two, you are owed 10 hours of overtime even though the two weeks total 80. This calculator checks each block of seven days separately when the weekly rule is selected.

Under the federal Fair Labor Standards Act, most hourly workers must be paid at least one and a half times their regular rate for hours over 40 in a workweek. A few states go further. California, for example, also counts overtime after 8 hours in a day and double time after 12.

Pay periods

Pay schedulePaychecks a yearHow it works
Weekly52Same day every week
Every two weeks (biweekly)26Every other week, sometimes 27 in a year
Twice a month (semimonthly)24Two fixed dates, such as the 15th and the last day
Monthly12Once a month

A twice a month pay period has 15 or 16 days, or 13 or 14 at the end of February, so the number of working days changes from one paycheck to the next. Choose the half month option that matches your period and leave unused rows blank.

What a good timesheet records

For each day: the date, the time work started, the time it ended, and unpaid breaks. Employers must keep records of hours worked for hourly staff, and keeping your own copy makes it easy to check a paycheck. A timesheet filled in each day is more accurate than one rebuilt from memory on payday.

Common questions

How do I calculate hours for a biweekly timesheet?

Add up each week separately, apply overtime to any week over 40 hours, then add the two weeks together.

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

They record the same thing. A time card usually covers one week and comes from a time clock. A timesheet covers a full pay period and is often filled in by hand or in a spreadsheet.

Can I open the download in Excel?

Yes. The CSV file opens in Excel, Google Sheets and Numbers with one row per day and a total row.

Last reviewed November 2026. Results are estimates for planning. See how we calculate and the disclaimer.