Time & attendance
Timesheet calculator
Free timesheet calculator for employers and hourly teams — a work hours calculator that totals hours and minutes from daily clock times. Enter clock-in, clock-out, and break minutes for each day, choose 1 week or 2 weeks, and split FLSA overtime per workweek. Optional pay rate settings estimate gross pay with overtime. Export CSV or PDF with no sign-up. For punch-card wording, see the time card calculator; for decimal conversion only, use the decimal hours calculator.
How this timesheet calculator works
Quick answer: For each workday, subtract clock-in from clock-out, deduct unpaid break minutes, and add the net hours. The calculator shows each day in hours:minutes and decimal hours, then totals the pay period. Under the federal FLSA, overtime is counted per workweek — in a two-week timesheet, week 1 and week 2 are calculated separately (not as one 80-hour block).
Example: 9:00 AM to 5:00 PM with a 60-minute lunch = 7.00 hours net (7:00 or 7.00 decimal). Seven thirty AM to 4:00 PM with a 30-minute lunch = 8.00 hours net.
Choose pay period length
Select 1 week or 2 weeks. Bi-weekly payroll still uses weekly overtime rules — each week gets its own regular and OT split.
Enter daily times
Add clock-in, clock-out, and break minutes for each day you worked. Optional fields capture employee name and pay period dates for exports.
Review totals and export
Copy total hours or export CSV/PDF for payroll prep. Add an hourly rate in advanced settings for a gross pay estimate.
Timesheet calculator with lunch breaks
Unpaid lunch and rest breaks should not count as work time. Enter break duration in minutes for that day — the timesheet subtracts it from gross hours automatically.
If you only need hours between two clock times once (not a full week), use the time duration calculator.
Bi-weekly timesheets and weekly overtime
Many employers run payroll every two weeks but still measure overtime by workweek (often Sunday–Saturday). This tool’s 2 weeks mode totals both weeks and applies the 40-hour overtime threshold separately to each week — so 45 hours in week 1 and 35 in week 2 yields 5 overtime hours, not zero.
State daily overtime (for example California’s rules) is not modeled here — use your payroll system or counsel for state-specific policies.
Timesheets in Excel, Sheets, and payroll
Payroll imports often expect decimal hours (7.75 instead of 7:45). This calculator shows decimals on every row and in exports. To convert a single value without a weekly grid, use the decimal hours calculator.
For a timesheet calculator Excel workflow: download our timesheet Excel template, or export CSV here and open it in Excel or Google Sheets. Columns typically include date, in, out, break, and net hours.
Monthly timesheet hours (estimate)
Quick answer: To estimate monthly hours from a weekly timesheet, add each week in the month, or multiply your average weekly total by 4.33 (weeks per average month). Example: 40 hours per week × 4.33 ≈ 173.2 hours in a typical month.
This tool is built for one- or two-week pay periods, not a 31-day grid. Run it once per week (or use 2 weeks mode), then sum the pay-period totals for the month — or use the formula above for a fast estimate.
FLSA overtime on timesheets
Under the Fair Labor Standards Act (FLSA), most non-exempt employees earn at least 1.5× their regular rate for hours over 40 in a workweek — even when payroll runs every two weeks. This timesheet calculator applies that rule separately to each week in bi-weekly mode.
Official overview: U.S. Department of Labor — overtime pay. State daily overtime (for example California after 8 hours in a day) is not modeled here — confirm with payroll or counsel.
For OT-first pay and tax estimates, use the overtime calculator alongside your timesheet totals.
Who uses a timesheet calculator?
Restaurant and retail managers verify crew hours before bi-weekly payroll. Healthcare and security supervisors total overnight and split shifts with break deductions. Construction foremen and field service leads collect weekly hours when a full time-clock system is not on site.
Hourly employees double-check gross hours and overtime before submitting a timesheet. Freelancers log billable days in a simple grid and export PDF for clients.
When manual spreadsheets fail, teams adopt time tracking software — but a free calculator stays the fastest way to total one or two weeks with lunch breaks and decimal hours.
More free tools
Discover more calculators for time tracking, payroll, and HR.
Frequently asked questions
Is there a free timesheet calculator?
Yes. This page is free in your browser — no account, credit card, or app install. Enter your week, review totals, and export CSV or PDF when you need a record.
How do I calculate timesheet hours?
For each day: (clock-out − clock-in) − unpaid break minutes = net hours. Add net hours across all days in the pay period. The calculator above does the math and shows decimal hours for payroll.
How many hours is 9:00 to 3:00 on a timesheet?
From 9:00 AM to 3:00 PM is 6 hours gross. If you take an unpaid 30-minute lunch, net time is 5.50 hours (5:30 or 5.50 decimal).
How many hours is 7:30 AM to 4:00 PM with a 30-minute lunch?
Gross time is 8.5 hours. After a 30-minute unpaid lunch, net work time is 8.00 hours (8:00 or 8.00 decimal).
Can a timesheet calculator track breaks?
Yes. Enter break minutes per day. Only unpaid breaks should be deducted; paid breaks count as work time and should be entered as zero break minutes or included in hours per your employer policy.
How do I calculate my monthly hours?
Add each workweek in the month, or multiply your average weekly hours by the number of weeks. A common estimate is average weekly hours × 4.33 for a calendar month. This tool focuses on one- or two-week pay periods — run it once per week and sum the totals for a month.
What is the difference between a timesheet and a time card?
A timesheet is the hours record you submit for a pay period (often weekly or bi-weekly). A time card is the daily punch in/out record. This timesheet calculator supports 1- and 2-week periods and export metadata; the time card calculator uses the same math with time-card-focused copy.
Does this timesheet calculator handle two-week pay periods?
Yes. Switch to 2 weeks, enter both weeks, and review per-week subtotals plus the pay-period grand total. Overtime still follows the federal 40-hour workweek rule separately for each week.
How does weekly overtime work on a timesheet?
For most non-exempt U.S. workers, hours over 40 in a workweek are overtime at least at 1.5× the regular rate. Adjust threshold and multiplier in advanced settings if your policy differs.
Does this calculator handle overnight shifts?
Yes. When clock-out is earlier than clock-in (e.g. 22:00 to 06:00), the shift crosses midnight automatically.
What is 15 minutes in decimal hours on a timesheet?
15 minutes = 0.25 decimal hours. Divide minutes by 60: 15 ÷ 60 = 0.25.
What is 30 minutes in decimal hours?
30 minutes = 0.50 decimal hours. Results show both hh:mm and decimal formats.
Can I add pay rate to my timesheet?
Open Pay rate & overtime settings and enter an hourly rate. The calculator estimates gross regular and overtime pay — not net pay after taxes.
Can I export my timesheet?
Yes. Use CSV or PDF export after entering your period. Optional employee and date fields appear on the export when filled in.
How do I calculate my hours for two weeks?
Switch to 2 weeks, enter clock-in, clock-out, and break minutes for each day in week 1 and week 2. The calculator shows per-week subtotals and a pay-period grand total in hours:minutes and decimal hours. Overtime is calculated per workweek, not across the full 14 days.
Is this a work hours calculator?
Yes. It is a work hours calculator for a full pay period: it adds net hours across multiple days with lunch breaks. For a single shift span (not a weekly grid), use the time duration calculator.
How do I build a timesheet in Excel?
Use columns for date, clock-in, clock-out, break minutes, and net hours. Formulas subtract breaks and sum the week. Download our timesheet Excel template, or enter times here and export CSV to open in Excel or Google Sheets.
Is this legal or payroll advice?
No. This page provides informational estimates only. Exempt status, state rules, rounding, and recordkeeping vary. Consult your employer, payroll provider, or counsel.