Work hours & pay
Weekly timesheet calculator
Type the hours you worked each day, set the overtime threshold and your rate, and get the week's regular hours, overtime and gross pay.
Enter hours as decimals: 15 min = 0.25, 30 min = 0.5, 45 min = 0.75. Overtime is counted per week, in the order the days are listed.
How the weekly timesheet is calculated
The calculator adds the seven daily entries to get the week's total. Every hour up to the threshold is a regular hour; every hour beyond it is an overtime hour. Gross pay is then regular hours × rate plus overtime hours × rate × multiplier. The running-total column shows on which day the threshold was crossed, which is the day payroll will flag.
Worked example with the default entries: Monday 8, Tuesday 8, Wednesday 8.5, Thursday 8 and Friday 9 hours make 41.5 hours. With a 40-hour threshold that is 40 regular hours and 1.5 overtime hours, all of the overtime landing on Friday. At $20 an hour and time and a half, regular pay is 40 × 20 = $800, overtime pay is 1.5 × 20 × 1.5 = $45, and the week grosses $845.
| Total hours | Regular | Overtime | Gross at $20, ×1.5 |
|---|---|---|---|
| 38 | 38 | 0 | $760 |
| 40 | 40 | 0 | $800 |
| 42 | 40 | 2 | $860 |
| 45 | 40 | 5 | $950 |
| 50 | 40 | 10 | $1,100 |
Filling in a timesheet without losing money
Write each day as decimal hours, not hours and minutes. A day of 8 h 45 min is 8.75, not 8.45; the second version quietly drops 18 minutes, and over a month of such entries the gap reaches a full shift. If your clock records times rather than durations, work out each day first (finish minus start minus unpaid break) and then type the result here.
Under the US Fair Labor Standards Act, non-exempt employees must receive at least 1.5 times their regular rate for hours over 40 in a workweek, and a workweek is a fixed, recurring 168-hour period chosen by the employer, not necessarily Monday to Sunday. Some places also count overtime per day: California, for example, pays overtime after 8 hours in a single day, which a weekly threshold does not capture. Paid holidays and sick days often do not count towards the overtime threshold because no work was performed, so check how your employer treats them before adding them in.
Set the threshold to match your contract. Part-time staff may have a lower threshold for extra hours, and some union agreements use 37.5 or 35 hours. If your agreement pays double time after a second threshold, run the week twice or split the extra hours by hand.
Frequently asked questions
How do I calculate overtime on a timesheet?
Add up all the hours for the workweek, subtract the threshold (usually 40), and the remainder is overtime. Multiply it by your hourly rate and the overtime multiplier, for example 1.5 for time and a half.
Do paid holidays count toward 40 hours for overtime?
Under US federal rules they usually do not, because overtime is based on hours actually worked. Some contracts and state rules are more generous, so check your agreement.
How do I write 7 hours 20 minutes on a timesheet?
Divide the minutes by 60: 20 / 60 = 0.33, so you enter 7.33. Common values are 0.25 for 15 minutes, 0.5 for 30 and 0.75 for 45.