Timesheet calculator: log your hours and see overtime
This timesheet calculator adds up your working hours: enter date, start, end and break on each line and it shows the total, your balance against target hours (overtime) and the hours per week. Save the result as an image or a CSV file for Excel. Night shifts across midnight work too.
Source: Wikipedia – Timesheet. Updated: .
How it is calculated
The working time of a day is end minus start minus break. The calculator adds all entries, compares them with the target and shows overtime or time under target.
How it is calculated
- Time per entry: end − start − break. If the end is before the start, the shift runs past midnight (+ 24 hours).
- Target: target hours × number of working days. A working day is every date with at least one entry, also for split shifts.
- Balance: actual minus target; positive is overtime.
- Weeks: totals per calendar week (ISO 8601, weeks start on Monday).
Input and export
- Times as 08:00, 8.30 or just 8; the break in minutes. You can paste rows from a spreadsheet, separated by tabs.
- The CSV file uses commas and decimal points and opens in Excel directly; ISO date and hh:mm are included.
The timesheet does not replace a certified system or any record-keeping your employer must keep. Your entries stay in your browser.
Several breaks, overtime limits and PDF
- Several breaks: add more values to the line – minutes or from–to, for example “10/01/2026; 8:00; 17:00; 15; 12:00-12:45” (60 minutes of breaks, 8:00 hours worked). Times also work with am/pm (“9am; 5:30pm”).
- Overtime after your own limit: first, everything above the daily limit counts per day; then, per calendar week, whatever remains above the weekly limit. Example with a daily limit of 8: days of 10, 8 and 9 hours give 3:00 overtime and 24:00 regular hours. At a rate of 20 and a 50 % premium that is 480 + 90 = 570.
- PDF with name and period: the “Timesheet as PDF” button creates a sheet with all entries, weekly totals and the summary. The name appears only in the PDF.
The limits are your setting, not legal advice: whether and when overtime is paid depends on your contract and local law. For a single day use the hours calculator, for a fixed week with break checks the work hours calculator, for a blank monthly sheet to print the timesheet template, and for overtime pay on its own the overtime calculator.
Frequently asked questions
How does the online timesheet work?
You enter date, start, end and break on each line. The calculator adds the working time, compares it with the target and shows overtime, weekly hours and a chart.
How do I enter a night shift?
Like any other shift, for example “10/07/2026; 22:00; 06:00; 30”. If the end is before the start, the shift runs past midnight and counts for the start day.
How is overtime calculated?
Actual hours minus target hours, where the target is target hours times the number of working days. A positive result is overtime, a negative one is time under target.
Can I open the data in Excel?
Yes: the button saves a CSV file. A double-click opens it in Excel; ISO date, decimal hours and hh:mm are included.
What happens with two entries on the same day?
Both times are added, but the date counts only once as a working day, for example for a split shift.
Are my entries private?
Yes. Everything is calculated in your browser; nothing is uploaded.
Can I calculate overtime after 8 hours a day or 40 hours a week?
Yes. Enter a daily limit, a weekly limit or both. The calculator separates regular hours from overtime and can add a premium such as 50 % to the pay. Which limit applies to you depends on your contract and local law.
Sources and legal basis
As of: · Editorial policy
Related tools
- Monthly timesheet templateTimesheet template for any month: prefilled with start, end and break times or blank to print, with daily hours and monthly total. Free, no sign-up.
- Work Hours CalculatorFree work hours calculator with lunch break: net hours worked per day or week, decimal hours for payroll, and overtime vs. your target hours.
- Hours calculatorHours calculator: hours between two times minus breaks, add or subtract hours and minutes, convert to decimal hours (7.75 h = 7:45), with pay and CSV.
- Overtime calculatorFree overtime calculator: compare scheduled and actual hours per week or month and work out overtime pay at time and a half (FLSA) or your own premium rate.
- Night shift differential calculator: extra pay for nights, Sundays and holidaysNight shift differential calculator: enter your hourly rate, night, Sunday and holiday hours and premium rates to see extra pay and gross. With a chart.
- Working days calculator: Germany 2026 / 2027Working days in Germany 2026: 252 to 254 depending on the state. Calculator with all public holidays, working days per month, 5- or 6-day week, plus 2027.
- Resume builder: US resume or UK CV with four clean layoutsFree resume builder for a US resume or UK CV: four layouts, optional photo, export as PDF or Word. No account, and your data stays on your own device.
- Complaint letter template: faulty goods, service, delivery or invoiceComplaint letter template for faulty goods, poor service, a wrong delivery or an incorrect invoice: fill in the letter and save as PDF or Word. Free.
- Delivery note template: goods handover with signature lineCreate a delivery note with items, quantities, order number and a signature line. Save as PDF or Word. Free, no account, and your data stays on your device.