The hundredth of an hour divides an hour into 100 equal fractions instead of 60 minutes. Each hundredth therefore represents 36 seconds. This notation system transforms time into a directly usable decimal value in a spreadsheet, payroll software, or an invoice, without intermediate conversion.
Minutes to hundredths conversion: the calculation mechanism to master
The principle is based on a simple arithmetic rule: divide the number of minutes by 60, then round to two decimal places. Thus, 15 minutes become 0.25 h, 45 minutes become 0.75 h, and 10 minutes correspond to approximately 0.17 h.
The difficulty arises with durations that do not fall on round fractions. A task of 23 minutes gives 0.38 h. In traditional sexagesimal notation (hours: minutes), adding 1 h 23 and 2 h 47 requires managing the transition to 60. In hundredths, the same operation simplifies to 1.38 + 2.78 = 4.16 h.
The gain is measured through repetition: a payroll manager who processes several dozen time sheets per month eliminates a source of error with each addition.
A detailed presentation of the hundredth of an hour on the Blog Entreprises site describes the most common correspondences between minutes and hundredths, with examples applied to time sheet entry.
- 0 to 6 minutes = 0.00 to 0.10 h (each block of 6 minutes is worth one-tenth of an hour)
- 30 minutes = 0.50 h, the only identical value between the two systems
- 59 minutes = 0.98 h, the maximum value before switching to the next hour
Billing in tenths of an hour: why 6-minute blocks dominate professional services
The hundredth of an hour finds its most direct application in billing by tenths of an hour. This granularity corresponds to 6-minute blocks, and it has become the reference in several service sectors (consulting, law, accounting).
The main argument lies in the perception of fairness. Billing in 15-minute blocks penalizes the client for short interventions: a 4-minute call ends up rounded to a quarter of an hour. With 6-minute blocks, the maximum rounding is limited to 5 minutes, which reduces the distortion between the actual time spent and the billed time.
An article published by Pomlo in 2026 on billing blocks compares 6-minute and 15-minute blocks. The conclusion is clear: the tenth of an hour reconciles sufficient precision and manual verifiability, whereas 15-minute blocks are deemed too aggressive for short tasks. For the provider, this transparency limits invoice disputes and strengthens the business relationship.
Impact on payroll and time tracking
The decimal system also applies on the employee side. The U.S. federal regulation 29 C.F.R. §785.48 allows rounding time tracking to the tenth of an hour (6 minutes), to the fifth minute, or to the quarter hour, provided that the rounding does not systematically disadvantage the employee over time. In France, the logic remains comparable: the rounding must remain neutral over a reference period to comply with labor law.
In practice, time management software records time entries in hundredths of an hour and applies the configured rounding. An employee clocking in at 8:07 sees their arrival time recorded as 8.12 h (rounded to the hundredth) or 8.10 h (rounded to the tenth). The difference seems minimal, but over a full month, it can represent several dozen minutes, hence the need to choose the right granularity.
Common conversion errors and pitfalls to avoid in a spreadsheet
The first pitfall is confusing 1.30 h with 1 h 30. In decimal notation, 1.30 h corresponds to 1 hour and 18 minutes (0.30 x 60 = 18). This confusion causes recurring discrepancies in manually entered time sheets.
The second pitfall concerns Excel formulas. Excel’s native time format is based on fractions of a day (1 hour = 1/24). Mixing an hh:mm format with an entry in hundredths skews all totals. The solution: dedicate a column to the decimal number format (two decimal places) and never apply the “Time” format to cells containing hundredths.
- Ensure that the cell is in “Number” format and not “Time” before entering hundredths
- Use the formula =MINUTE(cell)/60 to convert a native time to hundredths
- Check the weekly total by reconverting the decimal result into hours-minutes (decimal part x 60) for visual comparison
When the hundredth of an hour complicates instead of simplifying
The decimal system loses its advantage when the durations handled are always multiples of 15 minutes. In an environment where slots are set to the quarter hour (standard meetings, medical consultations), converting to hundredths adds a step without benefit. The hundredth of an hour is justified when durations are irregular, such as technical interventions, project tracking, or task-based billing.
Choosing the right time tracking granularity according to your activity
The choice between hundredth of an hour, tenth of an hour, and quarter hour depends on the balance between the desired precision and the administrative burden generated. Three criteria help to decide.
The first is the average duration of tasks. If most interventions last less than 10 minutes, rounding to the quarter hour generates too much distortion. The tenth of an hour (6 minutes) then becomes the reasonable floor.
The second criterion concerns the data entry tool. Time tracking software that automatically records task start and end times can work in hundredths effortlessly. Manual entry on paper, however, benefits from staying in tenths to limit mental calculation errors.
The third criterion is contractual. Some collective agreements or service contracts impose a billing granularity. Checking this point before configuring the system avoids having to reprocess months of data.
Switching to the hundredth of an hour does not require an organizational revolution. Often, it is enough to change a setting in the payroll software and train teams to read decimals. The return on investment is measurable from the first payroll cycle, when discrepancies in calculations between the HR department and time sheets disappear.
