Timesheet calculator
Enter a start time, an end time and unpaid break minutes for each day to get the hours per day in h:mm and as a decimal, plus total hours and total pay. A shift that ends after midnight is treated as ending the next day. Use it as a work hours calculator for weekly or monthly totals instead of adding up minutes by hand.
Loading the tool…
Processing and privacy: Hours are calculated and the CSV and PDF files are built inside your browser. Your times and rates are not sent to any server.
How to use it
- Add a row per day: date (optional), start time, end time and unpaid break minutes.
- If the end time is earlier than the start time, the tool treats it as an overnight shift that ends the next day and marks the row “+1 day”.
- Enter an hourly rate and currency to get an amount, and a daily regular-hours threshold with a multiplier if you pay overtime.
- Download the summary as CSV for a spreadsheet, or as PDF to print or send.
Example
09:00 to 17:30 with a 30 minute break is 8:00, that is 8.00 hours.
22:00 to 06:00 with a 60 minute break is 7:00, that is 7.00 hours, and the row is marked “+1 day”.
Both days together are 15:00 hours; at a rate of 50 the total pay is 750.00 SAR.
Limits and caveats
- Times are treated as wall-clock times exactly as typed. No time zone or daylight-saving adjustment is applied, so a day on which the clocks change will be an hour out.
- An end time earlier than the start always means the next day. The longest shift the tool accepts is under 24 hours, and an end time equal to the start is refused because a 0-hour and a 24-hour shift cannot be told apart.
- Breaks are subtracted from the shift, and a break longer than the shift is reported as an error instead of producing negative hours. Minutes are never rounded; the decimal column is rounded to two places for display only, while totals are summed from whole minutes.
- Pay is rounded once at the end to the currency’s decimals (two, or three for KWD, BHD, OMR and JOD). Adding up per-day amounts by hand can therefore differ from the total by one unit in the last place.
- The tool only counts hours. It does not know your labour law, public holidays or statutory overtime limits, and it does not calculate tax, insurance or deductions.
- Tested up to 62 rows (about two months) on one page.
Questions about this tool
How is a shift from 22:00 to 06:00 counted?
The end time is earlier than the start, so the tool treats the shift as ending the next day and adds 24 hours: 8 hours in total, minus the break. The row is marked “+1 day” so the result is never a surprise.
Why does the decimal column not always add up to the total hours?
The decimal column shows two decimals: 7 hours 20 minutes is 7.3333 and is displayed as 7.33. Totals are summed from whole minutes and then converted, so the total is the accurate figure.
Can I use the summary as an official payroll document?
The file shows what you typed and the arithmetic done on it. The tool does not verify attendance and does not know your labour law, so check the figures against your payroll system before relying on them.
How do I calculate hours worked?
Hours worked = end time − start time − unpaid break. From 08:30 to 17:00 with a 45 minute break is 8 hours 30 minutes minus 45 minutes = 7:45, which is 7.75 hours. Enter each day on its own row and the calculator adds all the days together.
How do I calculate pay from hours worked?
Multiply the regular hours by the hourly rate, then add the overtime hours multiplied by the rate and by the overtime multiplier. A 10-hour day with an 8-hour daily threshold, a rate of 50 and a multiplier of 1.5 gives 8 × 50 = 400 plus 2 × 50 × 1.5 = 150, so the pay is 550. You set the threshold and multiplier from your contract; the tool assumes no legal rate.