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.
Enter a start and end time for at least one day.
How to use the timesheet
- Choose the length of your pay period. Two weeks is the most common in the United States.
- Pick the first day of the period so each row shows its date.
- Enter start time, end time and unpaid break minutes for each day worked.
- 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 schedule | Paychecks a year | How it works |
|---|---|---|
| Weekly | 52 | Same day every week |
| Every two weeks (biweekly) | 26 | Every other week, sometimes 27 in a year |
| Twice a month (semimonthly) | 24 | Two fixed dates, such as the 15th and the last day |
| Monthly | 12 | Once 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.