How to use the timesheet calculator
- Choose Weekly or Biweekly. Biweekly shows two workweeks.
- For each day, enter the first in and out time. Use the second pair for a split shift, such as a lunch gap.
- Add your hourly rate if you want gross pay. Keep overtime on to apply time and a half after 40 hours in each week.
- Optionally type an employee name. It is printed on the PDF and CSV only and is never put in a shared link.
- Use Download PDF for a printable timesheet with signature lines, or Download CSV for a spreadsheet.
Formula
Day = (out 1 - in 1) + (out 2 - in 2); add 24 hours to any pair that crosses midnight
Week total = sum of its 7 days
Overtime for each week = week total - 40 hours (if positive)
Period total = week 1 + week 2
Pay = regular hours x rate + overtime hours x rate x 1.5
The two weeks are never averaged. 50 hours in one week and 30 in the next is 10 overtime hours, not zero.
Worked example: why weeks are kept apart
Week 1 is five days from 8:00 AM to 6:00 PM, or 10 hours a day, so 50 hours. Week 2 is five days from 8:00 AM to 2:00 PM, or 6 hours a day, so 30 hours. The period total is 80 hours.
At $10.00 an hour, the federal rule makes week 1 pay 40 x $10.00 + 10 x $15.00 = $550.00 and week 2 pay 30 x $10.00 = $300.00. Gross pay is $850.00.
If you averaged the two weeks to 40 hours each, you would get $800.00 and underpay the overtime by $50.00.
What counts as a workweek
The Fair Labor Standards Act defines a workweek as a fixed, repeating period of 168 hours, which is seven consecutive 24-hour periods. It can begin on any day and at any time, but once set it does not move around to avoid overtime.
Treat "week 1, day 1" in this tool as the first day of your employer's workweek. Biweekly pay periods are two workweeks back to back.
Split shifts and lunch gaps
The two in/out pairs let you record a gap without typing a break. The second pair must start after the first pair ends. A second pair that overlaps the first is flagged so a typo cannot double count time.
Keeping a timesheet that holds up
Record times when they happen, not from memory at the end of the period. Note any corrections with a date and initials, keep the signed copy and compare your total with your pay stub. If the totals differ, bring the timesheet to your payroll contact.
Assumptions and limits
- Overtime is calculated under the federal FLSA only. State daily or seventh-day overtime rules are not applied.
- Each workweek is seven days starting at "day 1." If your employer uses a different week, line the days up to match.
- Times are wall-clock times. Daylight saving changes inside a period are not adjusted.
- Saved entries stay in your browser. Names are not saved or shared by link.
Frequently asked questions
Does a biweekly timesheet have 80 hours of overtime-free time?
Not under federal law. Overtime is judged one workweek at a time, so hours over 40 in either week are overtime even if the two-week total is 80 or less.
Can I print a timesheet with signature lines?
Yes. Download PDF produces a US Letter page with employee and supervisor signature lines. Print also works from your browser.
Is my employee name stored?
No. The name is used only to label the file you download. If you use "Save in this browser," the name is not included.