Runs in your browser · nothing is uploaded
Timesheet Calculator
This timesheet calculator takes start and end times for each shift and your unpaid breaks, and adds up the week or fortnight in hours and minutes and decimal hours, with optional overtime and pay.
Auf Deutsch: Arbeitszeitrechner
Estimate only — not a payroll or legal calculation. Check overtime, penalty rates and breaks against your contract, award or local law.
Filling in a timesheet
Typing times
Type times however you like — 9, 0930, 9:30, 9.30am or 17:30. They tidy up when you move to the next box. Use 24:00 for a shift that ends at midnight.
Breaks
Enter unpaid breaks in minutes. For several breaks, add them with a plus: 30+15. Paid breaks don't need entering — they're part of the shift.
Split shifts
Use “Add shift” for a second shift on the same day. Each shift is checked on its own, and the day shows the combined total.
Minutes to decimal hours
| 5 min | 0.08 h |
|---|---|
| 10 min | 0.17 h |
| 15 min | 0.25 h |
| 20 min | 0.33 h |
| 30 min | 0.50 h |
| 40 min | 0.67 h |
| 45 min | 0.75 h |
| 50 min | 0.83 h |
Frequently asked questions
How do I calculate hours worked?+
Subtract the start time from the end time, then take off unpaid breaks. 9:00 to 17:30 is 8 hours 30 minutes; with a 30-minute lunch that's 8:00, or 8.00 in decimal hours.
How do I convert minutes to decimal hours?+
Divide the minutes by 60. 15 minutes is 0.25, 30 is 0.5 and 45 is 0.75, so 7 hours 45 minutes is 7.75 hours. Payroll usually multiplies decimal hours by the hourly rate.
How are night shifts handled?+
If the end time is earlier than the start time, the shift is treated as ending the next day and marked “ends next day”. 22:00 to 06:00 is 8 hours. The shift counts toward the day it starts.
What about daylight-saving changes?+
By default the calculator uses clock time, so 22:00 to 06:00 is always 8 hours. Switch to “Elapsed time” and pick a time zone to count the real hours: on the night clocks go back that shift is 9 hours, and on the night they go forward it's 7.
Does it work for fortnightly pay, like in Australia?+
Yes. Choose “Fortnightly” to get 14 days with a total for each week and the fortnight, or “Custom” for any period up to 62 days. Weekly overtime is worked out separately for each week of the fortnight.
How is overtime calculated?+
You set the rules: hours per day and/or per week after which overtime starts, and the overtime rate. Daily overtime is counted first, then weekly overtime on the remaining hours, so no hour is counted twice. It's an estimate — check penalty rates and awards with your employer.
Can I round time to the nearest 15 minutes?+
Yes. Under “Round each shift” pick 5, 6, 10 or 15 minutes, and each shift's worked time is rounded to the nearest step, as many time clocks do. To the nearest 15 minutes, 7:52 becomes 7:45 and 7:53 becomes 8:00. Rounding to 6 minutes gives tenths of an hour (0.1 h). Check your employer's rounding policy before relying on it.
How do I enter times and breaks?+
Type times the way you write them: 9, 9:30, 0930, 17:30, 9am or 5:30 pm all work, and you can show the timesheet in 24-hour or 12-hour format. Enter unpaid breaks in minutes, or several at once like 30+15 or 1:00, 15.
How do I record a split shift or two jobs on one day?+
Click “Add shift” under the day to add another start and end time with its own breaks. The day shows the total of all its shifts, and every shift counts toward the weekly totals and overtime.
Can I export or print my timesheet?+
Yes. “CSV” downloads every shift with start, end, breaks and hours (as h:mm and decimal) for Excel or Google Sheets, “Copy” copies a text summary, and “Print / PDF” makes a printable timesheet with your name, totals and signature lines for you and an approver.
Is my timesheet stored or sent anywhere?+
Nothing is uploaded. Your timesheet is only saved — in this browser, on this device — if you tick “Save this timesheet on this device”. Untick it to delete it.
More free Northlane tools
- Age calculatorExact age, days between dates
- Profit margin calculatorMargin, markup, break-even
- Mortgage calculatorMonthly payment, EMI, schedule
- Tip calculatorCalculate tips, tax and service charges with equal or weighted group splits, and convert the total into your home currency.
- Sales tax calculatorCalculate inclusive or exclusive sales tax with editable state and local rates.
- Discount calculatorApply stacked discounts, calculate savings and recover an original price.
- Savings goal calculatorProject savings and calculate the monthly contribution needed for a goal.
- Gas cost calculatorEstimate fuel, tolls and trip costs; compare two vehicles.
- Amortization calculatorCompare monthly and biweekly schedules, extra payments, interest-only loans and balloon balances.
- Bank statement to Excel converterBank statement to Excel & CSV
- All toolsBrowse the full collection