How to use the Timesheet Calculator
- Optionally pick the Monday of the week, enter your hourly rate and choose an overtime rule.
- For each day you worked, enter the start time, end time and unpaid break in minutes. Leave days off blank.
- Read the daily and weekly totals in hours and minutes and in decimal hours, plus regular and overtime hours and pay.
- Copy the timesheet, download it as a CSV for Excel or Google Sheets, or print it.
Features
- Monday to Sunday with start, end and break for each day
- Overnight shifts handled automatically
- Totals in hh:mm and decimal hours
- Daily or weekly overtime with any threshold and multiplier
- Gross pay at your hourly rate
- Copy, CSV download and print; saved on this device
How hours worked are calculated
For each day the calculator uses a simple formula: hours worked = end time − start time − unpaid break. Times are converted to minutes after midnight, so 8:30 AM is 510 and 5:15 PM is 1,035. The difference, 525 minutes, minus a 30-minute lunch gives 495 minutes, or 8 hours 15 minutes.
If the end time is earlier than the start time, the shift is treated as overnight and 24 hours are added to the end. A shift from 10:00 PM to 6:30 AM with a 30-minute break is 8 hours 0 minutes. The table marks these rows with “+1 day”.
Hours and minutes vs decimal hours
Payroll systems usually want decimal hours, because pay is calculated by multiplying hours by a rate. To convert, divide the minutes by 60: 8 hours 15 minutes is 8.25 hours, not 8.15. This is the most common timesheet mistake, and on a whole week it can cost real money.
| Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|
| 5 | 0.08 | 35 | 0.58 |
| 10 | 0.17 | 40 | 0.67 |
| 15 | 0.25 | 45 | 0.75 |
| 20 | 0.33 | 50 | 0.83 |
| 25 | 0.42 | 55 | 0.92 |
| 30 | 0.50 | 60 | 1.00 |
Overtime rules
Choose the rule that matches your job:
- Weekly overtime counts hours above a weekly threshold. Under the US Fair Labor Standards Act, non-exempt employees must be paid at least 1.5 times their regular rate for hours over 40 in a workweek.
- Daily overtime counts hours above a daily threshold, such as 8 hours. Some US states, including California, and many union contracts use daily overtime.
- None treats every hour as regular time, which suits salaried staff and contractors who simply log hours.
Rules vary by country, state, industry and contract, and some places combine daily and weekly limits or pay double time after a second threshold. Check your contract or local labor authority and set the threshold and multiplier to match.
What counts as a break?
Enter only unpaid breaks, usually meal breaks of 30 minutes or more. Under US federal rules, short rest breaks of about 5 to 20 minutes are normally counted as paid working time, so do not subtract them. Other countries set their own minimum breaks.
Tips for accurate timesheets
- Record times daily rather than reconstructing the week on Friday.
- Note why a shift ran long, especially if overtime needs approval.
- Keep the CSV export: it opens in Excel or Google Sheets and gives you a record if a paycheck looks wrong.
- To see what your rate means per month or year, use the Salary Calculator; for a single time span, the Hours Calculator is quicker.
Pay figures are gross estimates for information only and are not financial or legal advice.
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 break. For example, 9:00 AM to 5:30 PM with a 30-minute lunch is 8 hours 30 minutes minus 30 minutes, which is 8 hours.
How do I convert hours and minutes to decimal hours?
Divide the minutes by 60 and add them to the hours. 7 hours 45 minutes is 7 + 45/60 = 7.75 hours. The Decimal column does this for every day.
Does the calculator handle night shifts?
Yes. If the end time is earlier than the start time, the shift is treated as ending the next day, so 10:00 PM to 6:00 AM is 8 hours.
How is overtime pay calculated?
Overtime hours are paid at your hourly rate multiplied by the overtime multiplier, usually 1.5. Choose Daily or Weekly, set the threshold, and the calculator splits your hours into regular and overtime.
Is my timesheet saved?
Your entries are saved only in this browser so they are still there when you come back. Nothing is uploaded, and Clear removes them.