RandoziTimesheet Hours Calculator
Add one row per period of work with a start time, an end time and a break in minutes. You get the net time of each row as hours and minutes and as decimal hours, plus the total, with optional rounding to 5 or 15 minutes. Night shifts are handled with a tick box. This is a calculator, not a payroll tool.
Work periods
Up to 31 rows, 24-hour clock. A row with no start, no end and no break is ignored; a break without times is an error.
Total hours worked
14:45 h
| Row | Net (H:MM) | Decimal hours |
|---|---|---|
| Mon | 7:00 | 7.00 |
| Tue | 7:45 | 7.75 |
| Total | 14:45 | 14.75 |
Net time = end − start − break (never below 0). Decimal hours = minutes ÷ 60, shown with 2 decimals; the total decimal comes from the total minutes, so it can differ by 0.01 from the sum of the rows. This is a calculator, not a payroll tool: it knows nothing about overtime, paid breaks, rest periods or labour law. Nothing you type leaves your browser.
How it works
- For each row, type the start and end on a 24-hour clock (09:00 and 17:00) and the break in minutes.
- Tick “Shift crosses midnight” on a row that ends after midnight, such as 22:00 to 06:00.
- Add rows for the other days, up to 31, and read the total.
- Pick a rounding if your timesheet uses one, then copy the summary.
What people use it for
Filling in a weekly timesheet
Turn the times you clocked into net hours per day and a total to write on the form.
Invoicing by the hour
Get decimal hours, such as 7.75, to multiply by a rate.
Checking night shifts
Count a 23:00 to 01:00 shift as 2 hours without doing the sum across midnight by hand.
Questions
- How are the hours calculated?
- Net time = end − start − break, in minutes. 09:00 to 17:00 with a 60-minute break is 480 − 60 = 420 minutes, shown as 7:00 and as 7.00 decimal hours (minutes ÷ 60). Net time is never negative: a break as long as the shift gives 0 with a warning.
- How do shifts past midnight work?
- If the end is not after the start, the row counts as 0 with a warning, unless you tick “Shift crosses midnight” on that row. Then 24 hours are added to the end: 23:00 to 01:00 is 2:00. The same time for start and end with the box ticked counts as 24 hours.
- How does rounding work?
- Each row's net time is rounded to the nearest 5 or 15 minutes before the rows are added up, so the total is the sum of the rounded rows. Employers and countries differ on whether and how to round, so follow the rule that applies to you. Total decimal hours come from the total minutes and can differ by 0.01 from the sum of the rows.
- Is this suitable for payroll or labour law checks?
- No. It does not know about overtime, paid breaks, rest periods, minimum pay or the rules of your country or contract. It only adds up the times you type, and nothing you type leaves your browser.