Calculating working time looks easy until a day includes an unpaid break, two separate work periods, a shift that crosses midnight or a decimal value such as 7.6 hours. A reliable calculation starts by separating span of time, non-working interruptions and time actually counted as worked.
GuideBest practicesBeginner
Working time: understanding hours worked, breaks and schedule calculations
Learn how to calculate actual working time, handle breaks, split shifts, midnight crossings and decimal hours.
Show contents
Calculating a simple working day
For a 9:00 to 17:00 day with a 45-minute unpaid break, the span is eight hours. Counted working time is therefore 8 h − 45 min = 7 h 15 min.
The work hours calculator performs this calculation without forcing you to convert minutes mentally. It is especially useful when schedules vary from one day to the next.
Clock times are not ordinary decimal numbers. Subtracting 17.30 − 9.45 as decimals does not correctly represent 17:30 minus 09:45 because minutes use base 60.
Split shifts: add the actual work periods
Consider 08:30–12:00 and 13:15–17:45. The morning period is 3 h 30 and the afternoon period is 4 h 30, for a total of 8 hours.
Adding the periods actually worked is often safer than starting with the full span and reconstructing every interruption. Bethemesh therefore lets you enter two work intervals for each day.
If a break is already represented by the gap between the two intervals, do not subtract it again as an additional break.
What if a shift crosses midnight?
A 22:00–06:00 shift lasts eight hours, not minus sixteen. The calculation must recognise the change of date.
This becomes particularly important for night shifts. Total shift duration and the number of hours falling inside a defined night period are different figures. Night work: hours, premiums and compensatory measures explains that distinction.
Hours and minutes versus decimal hours
7 h 30 min equals 7.5 decimal hours. 7 h 45 min equals 7.75, not 7.45.
The formula is decimal hours = hours + minutes ÷ 60. Thus 7 h 36 min equals 7 + 36/60 = 7.6 hours.
Use the decimal hours converter when moving between a timesheet, payroll data and spreadsheet calculations.
From a day to a week
Once each day is correct, add the durations for the relevant period. A week containing 7 h 30, 8 h, 6 h 45, 7 h 45 and 7 h totals 37 hours.
That total alone does not determine the legal classification of the hours. Rules depend on the country and the applicable employment framework. For the French rules covered by Bethemesh’s France-specific calculators, see Overtime: how to calculate it and understand premiums.
Part-time work is a separate calculation
For a part-time employee, hours above the contractual schedule may follow rules that differ from ordinary full-time overtime. The French-specific part-time additional hours guide explains the distinction and links to the dedicated calculator.
Building a reliable record
For each day, keep the date, each start and end time, non-working breaks and the daily total. Add a project reference or hourly rate only when it is useful.
The Excel timesheet generator creates a monthly workbook for this purpose. How to track working hours in Excel explains how to keep source data separate from calculations.
Working time is not the same as payroll
A total number of hours is only a starting point. Pay may also depend on overtime, part-time additional hours, night work, Sunday or public-holiday work and the applicable agreement.
First establish the time accurately, then classify the hours. The salary calculator can help with basic pay conversions, while the specialised calculators handle particular scenarios.
Key points
Reliable time calculations begin with clean source data: work periods, breaks and midnight crossings. Decimal hours are simply another representation of the same duration.
From there, continue with the guide that matches the situation: overtime, part-time additional hours, night work, Sunday and public-holiday work, compensatory rest or Excel timesheets.