Calculate weekly hours, pay, and billable time

Use the Timesheet Calculator to turn a 5- or 7-day work schedule into a clear weekly breakdown. Enter start and end times, subtract unpaid breaks, and add billable hours only when they differ from net worked hours. The calculator separates regular and overtime hours, estimates pay, and produces an invoiceable amount based on the hourly rate.

How to use the Timesheet Calculator

1. Choose a 5-day or 7-day workweek.
2. Enter an hourly rate.
3. Enable or disable the weekly overtime rule. When it is enabled, set the weekly threshold and multiplier you want to model.
4. Enter start and end times in 24-hour HH:MM format for each worked day.
5. Add any unpaid break in minutes.
6. Leave billable hours blank to count all net worked hours as billable, enter a smaller number for a partial billable day, or enter 0 for a fully non-billable day.

What the results mean

• Total worked hours are the sum of net daily hours after unpaid breaks.
• Regular hours are the worked hours allocated up to the configured weekly overtime threshold.
• Overtime hours are later weekly hours beyond that threshold when the overtime rule is enabled.
• Billable hours are the entered billable hours, capped at each day’s net worked hours.
• Non-billable hours are total worked hours minus billable hours.
• Estimated regular pay and estimated overtime pay use the hourly rate and the configured multiplier.
• Estimated total pay is regular pay plus overtime pay.
• The invoiceable amount is billable hours multiplied by the hourly rate. It does not add an overtime premium automatically.

How the calculation works

For each completed day, the calculator finds the elapsed time from start to end, applies a next-day rollover when the end time is earlier, and subtracts the unpaid break. A break can never make worked hours negative. Blank billable hours default to all net worked hours, while an explicit 0 remains 0. Weekly regular and overtime hours are allocated chronologically from Monday through Sunday so the same hour is never counted twice.

Convert hours and minutes to decimal hours

Payroll and invoicing often use decimal hours. Convert the minutes by dividing them by 60, then add the result to the full hours. For example, 8 hours and 45 minutes becomes 8 + 45/60 = 8.75 hours.

Overnight shifts and edge cases

When an end time is earlier than the start time, the calculator treats the shift as ending the next day. A start and end time that are equal produce zero hours. A blank day also contributes zero hours. If the unpaid break equals or exceeds the shift duration, the day’s net worked hours are zero. Billable hours cannot exceed that day’s net worked hours.

Overtime is configurable, not legal advice

The overtime threshold and multiplier are planning inputs. They do not determine whether a worker is legally entitled to overtime or whether a timesheet complies with employment law, payroll rules, a collective agreement, or a contract. Requirements vary by jurisdiction and worker classification. In the United States, covered nonexempt employees generally receive overtime after 40 hours in a workweek, but exemptions and state rules can change the result; review the U.S. Department of Labor overtime guidance and obtain qualified advice when needed.

Frequently asked questions

What happens if billable hours are left blank?

All net worked hours for that day are treated as billable. Enter 0 when none of the day should be billable.

Can billable hours be greater than worked hours?

No. The calculator caps billable hours at the net worked hours for that day.

Why can estimated pay differ from the invoiceable amount?

Estimated pay includes regular and configured overtime pay. The invoiceable amount uses billable hours multiplied by the hourly rate and excludes non-billable time.

Can this replace payroll or legal review?

No. It is a planning estimate based on your inputs. Confirm payroll, tax, break, overtime, contract, and invoicing rules separately.