Free tool · no sign-up
Timesheet calculator
Calculate the working hours for a full week: several time slots a day, paid or unpaid breaks, shifts that end after midnight. Export the result as CSV or print it.
The calculation runs in your browser: no data is sent.
How do you calculate your working hours?
To calculate your working hours for a day:
- Calculate the duration of each time slot: end time minus start time. For example, from 08:30 to 12:30 = 4 h 00 min.
- Add up the time slots if the day has several.
- Subtract unpaid breaks. Paid breaks remain included in working time.
- Add up the days to get the week total.
Examples
Standard day. From 08:30 to 17:00 with a 30-minute unpaid lunch break: 8 h 30 min − 0 h 30 min = 8 h 00 min.
Split shift. From 10:30 to 14:30 then from 18:00 to 22:30: 4 h 00 min + 4 h 30 min = 8 h 30 min. The afternoon gap is not working time.
Work after midnight. From 18:00 to 01:30: 6 h 00 min until midnight + 1 h 30 min = 7 h 30 min. In a spreadsheet, the simple subtraction 1:30 − 18:00 gives a negative result: you have to add 24 hours. Good to know: in Cloketa, hours clocked after midnight are counted on the day they are worked; the total remains accurate.
38-hour week. 5 days of 7 h 36 min = 38 h 00 min. In decimal, 7 h 36 min = 7.6 h (36 minutes ÷ 60 = 0.6).
Hours and minutes or decimals?
Hours are often expressed in two ways: 7:45 (7 hours 45 minutes) or 7.75 h (decimal format, useful for payroll and spreadsheets). To convert, divide the minutes by 60: 45 ÷ 60 = 0.75. The calculator shows both.
Paid or unpaid break?
Whether a break is paid depends on your work regulations, your sector and your contract. The calculator lets you choose for each break; it does not determine which rule applies to you.
This calculator performs an arithmetic calculation based on the hours you enter. It does not determine the legal qualification of the time (working time, overtime, night work, pay supplements), nor the pay due. If in doubt, consult your social secretariat.
Free trial
What if the hours added themselves up?
With Cloketa, each worker clocks in with a single tap or follows an automatic schedule. Time slots, breaks and night work are calculated for the whole team, every week.
Important information Cloketa is a working time recording tool. It does not provide legal or HR advice and does not replace any official declaration or application. Each employer remains responsible for their own obligations: if in doubt, consult your social secretariat or an adviser.