Timesheet Calculator

Total hours, deduct breaks and apply federal, California or custom overtime for one worker or a whole crew. Free, no sign-up, and nothing you type leaves your browser.

$
DayClock in, clock out and unpaid breakHours

This worker

0.00hrs0:00 total
0.00Regular
0.00Overtime 1.5×
0.00Double time 2×

Entries are saved in this browser only. Nothing is sent to Truein.

How to Use the Timesheet Calculator

1. Set the pay period. Choose weekly, bi-weekly or semi-monthly, then pick the start date. The grid fills with the right days automatically.
2. Pick an overtime rule. Federal applies 1.5× after 40 hours in a workweek. California adds daily overtime after 8 hours, double time after 12, and the 7th-consecutive-day rule. Custom lets you set your own daily and weekly thresholds and multiplier for other states or union agreements. Choose "No overtime" to total hours only.
3. Enter clock-in and clock-out times. Type 7:30, 730, 7.5 or 7:30am. Switch to 24-hour if your crew uses military time. Shifts that end after midnight are handled automatically.
4. Deduct unpaid breaks. Set a default break once and it applies to every shift; change it on any day that was different. Add a second shift on days with a split schedule.
5. Add the rest of the crew. Click "Add worker", or "Duplicate this worker" when several people share a schedule. See crew totals and total labor cost.
6. Print, download or email the result. Totals show in decimal hours (what payroll systems want) and in hours and minutes.Entries stay in your browser so you can come back and finish later. Clearing browser data removes them.

How to Calculate Timesheet Hours Manually

If you're checking a timesheet by hand or building a spreadsheet, these are the formulas the calculator uses.

Hours Worked

Hours worked = (Clock out − Clock in) − Unpaid break
Example: 6:45 AM to 4:15 PM with a 30-minute lunch is 9 hours 30 minutes minus 30 minutes, or 9 hours.

Converting Minutes to Decimal Hours

Payroll systems need decimal hours, not hours and minutes. Divide the minutes by 60 and add them to the hours: 7 hours 15 minutes becomes 7 + (15 ÷ 60) = 7.25 hours.

MinutesDecimalMinutesDecimalMinutesDecimal
50.08250.42450.75
100.17300.50500.83
150.25350.58550.92
200.33400.67601.00
MinutesDecimalMinutesDecimal
50.08350.58
100.17400.67
150.25450.75
200.33500.83
250.42550.92
300.50601.00

Excel and Google Sheets Formulas

With clock-in in A2, clock-out in B2 and break minutes in C2, formatted as times:

Overtime Rules Built Into This Calculator

Overtime is where most hand-calculated timesheets go wrong, because the rule depends on where the work happens, not where the company is based. The calculator applies the two rules that cover most US hourly crews, and lets you set your own for everywhere else.

RuleFederal (FLSA)California
Weekly overtimeOver 40 hours in a workweek at 1.5×Over 40 regular hours in a workweek at 1.5×
Daily overtimeNoneOver 8 hours in a day at 1.5×
Double timeNoneOver 12 hours in a day at 2×
7th consecutive dayNoneFirst 8 hours at 1.5×, hours beyond 8 at 2×
WorkweekAny fixed, recurring 7-day period. Set the start day in the calculator to match your payroll workweek.

Several other states apply daily overtime or have their own thresholds (Alaska and Nevada after 8 hours a day, Colorado after 12), and union agreements and prevailing-wage jobs often set stricter terms. Use the Custom rule to enter those thresholds, and check your state's labor department when your crew works elsewhere. Official sources: US Department of Labor on overtime and California DIR overtime FAQ.This calculator is a worksheet, not legal advice. Exempt status, meal-period premiums and alternative workweek schedules are outside its scope.

Timesheet Calculation for Construction Crews and Site Workers

Most online time card calculators assume one person, one shift, one site. Construction, specialty contractor and facility management timesheets rarely look like that. This one was built for the way site work is actually logged.

Split Shifts and Overnight Work

A crew that pours in the morning, stops for the inspection and comes back at 4 PM needs two shift rows on one day, not a single in-and-out that silently pays the gap. Night shifts that clock in at 9 PM and out at 5:30 AM are totaled correctly across midnight, and the day is flagged so you can see it at a glance.

Daily Overtime Adds Up Fast on Long Days

A 10-hour day looks like 10 hours on a federal timesheet. In California it's 8 regular and 2 at 1.5×, and on day seven it's all overtime. Across a 20-person crew that difference is real money and a real compliance exposure, which is why the calculator keeps daily and weekly overtime separate instead of lumping them together.

Rounding Should Be Consistent, Not Convenient

Federal regulations allow rounding punches to the nearest quarter hour as long as it works both ways over time. Pick the rounding increment your payroll uses and apply it to everyone; the calculator rounds each clock-in and clock-out, not the daily total, which is how time clocks do it.

Crew Totals Before Payroll

Add each worker as a tab, or duplicate one worker when the whole crew ran the same shift, enter a pay rate, and the crew panel shows total hours, overtime hours and gross labor cost for the period. For a weekly check against the job cost report, that's usually all a superintendent needs.

Common Timesheet Errors on Job Sites

Totaling hours is the easy part. These are the errors that show up when paper or spreadsheet timesheets meet payroll.