Timesheet Calculator with Breaks

Add up a week of shifts with unpaid breaks and overnight shifts. Shows decimal hours, overtime over 40 hours and gross pay, then prints or exports.

Enter start and end times and the length of any unpaid break for each day, and the calculator works out the hours for the day and the week in both hours-and-minutes and decimal form, splits regular and overtime hours, and — if you enter a rate — the gross pay. Overnight shifts are handled automatically. Your entries stay in this browser so you can come back to them, and you can print the week or download it as a spreadsheet.

How the hours are worked out

Each day is the end time minus the start time, minus the unpaid break. If the end time is earlier than the start time, the shift is treated as running past midnight. Totals are shown as hours and minutes (7:45) and as decimal hours (7.75), which is what most payroll systems want.

To convert minutes to decimal hours yourself, divide by 60: 15 minutes is 0.25, 30 is 0.5, 45 is 0.75, and 20 minutes is 0.33.

Overtime rules

Under the US Fair Labor Standards Act, non-exempt employees are owed at least one and a half times their regular rate for hours over 40 in a workweek. That is the default here.

Some states go further. California, for example, also requires overtime for hours over 8 in a workday, with additional rules for 7th consecutive days and double time after 12 hours. Tick the daily-overtime option for the over-8 rule; the calculator does not model every state's special cases, so check your state labor department's guidance before running payroll from it.

Breaks: paid or unpaid?

Federal law does not require meal or rest breaks, but when an employer offers short breaks of about 5 to 20 minutes, federal rules treat them as paid work time. Bona fide meal periods — usually 30 minutes or more, fully relieved of duty — can be unpaid. Only enter unpaid time in the break column.

Several states set their own break requirements. If you are unsure whether a break is paid, record it and ask, rather than deducting it.

Keeping good time records

Employers covered by the FLSA must keep accurate records of hours worked each day and each workweek. A weekly sheet signed by the employee and a supervisor is a simple habit that avoids disputes later.

For a team, a reusable spreadsheet that holds a schedule and a timesheet per person is less work than re-entering each week — see the templates below.

Frequently asked questions

How do I calculate hours worked with a lunch break?

Subtract the start time from the end time, then subtract the unpaid lunch. 8:00 to 16:30 with a 30-minute unpaid lunch is 8 hours.

How do I convert minutes to decimal hours?

Divide the minutes by 60. 15 minutes = 0.25, 30 = 0.5, 45 = 0.75. So 7 hours 45 minutes is 7.75 decimal hours.

When does overtime start?

Under federal law, after 40 hours in a workweek for non-exempt employees, at 1.5 times the regular rate. Some states, such as California, also count hours over 8 in a day.

Does the calculator handle night shifts?

Yes. If the end time is earlier than the start time, the shift is treated as crossing midnight — 22:00 to 06:00 is 8 hours.

Is my data saved?

Only in your own browser, on this device. Nothing is sent to us. Clearing your browser data removes it.

Related templates