Skip to content

Archilinux

Linux, logiciels libres et infographie

Converting Hours to Hundredths: Simplify Calculations and Optimize Time Management

Converting hours and minutes into hundredths means converting a sexagesimal format (base 60) into a decimal format (base 100). This common operation…

Femme calculant la conversion des heures en centièmes dans un carnet au bureau

Converting hours and minutes into hundredths means translating a sexagesimal format (base 60) into a decimal format (base 100). This seemingly straightforward operation is the source of most discrepancies between time records and payslips.

The formula fits on one line, but the order in which results are rounded, the display format in a spreadsheet, and the method used to calculate weekly totals can all change the final amount. Measuring these discrepancies helps identify where errors occur and how to prevent them.

Differences between minutes and hundredths: conversion table in 5-minute increments

The middle column in the table below shows the exact decimal value. The right-hand column shows the difference in hundredths when rounded to two decimal places. These tiny discrepancies can add up over a month and affect a line on a payslip.

Minutes Exact hundredths Rounding difference (2 decimal places)
5 min 0,0833… +0,003
10 min 0,1666… +0,003
15 min 0,25 0
20 min 0,3333… +0,003
25 min 0,4166… +0,003
30 min 0,50 0
35 min 0,5833… +0,003
40 min 0,6666… +0,003
45 min 0,75 0
50 min 0,8333… +0,003
55 min 0,9166… +0,003

Only multiples of 15 minutes (15, 30, 45) produce an exact decimal value. All other minute values produce a repeating decimal, and therefore require rounding. Converting hours into hundredths relies on dividing by 60, which gives an exact result in only three out of twelve cases per 5-minute increment.

Man using a calculator to convert hours into hundredths in a home office

How rounding discrepancies add up on a monthly payslip

Rounding each daily time entry before totaling the hours for the month does not produce the same result as first adding all the minutes and then converting the total into hundredths. The order of rounding changes the monthly decimal total.

Consider an employee who clocks 7 h 20 min each day. In exact hundredths, this equals 7.3333 h. Rounded to two decimal places each day, it becomes 7.33 h. Over 22 working days, the total rounded daily comes to 161.26 h. The total calculated by adding the minutes first (22 x 440 min = 9,680 min, or 161.3333 h, rounded once to 161.33 h) differs by 0.07 h.

A difference of a few hundredths of an hour per month may seem negligible. But when applied to an hourly rate, it creates a tangible difference on the “regular hours” or “overtime” line of the payslip. Adding up the raw durations before converting reduces the cumulative discrepancy.

Practical rule for payroll managers

Add up the hours and minutes for the week or month in sexagesimal format (h:mm), then divide the total by 60. Rounding just once, at the end, limits discrepancies.

Excel display format and working-time calculation errors

An Excel spreadsheet can display a correct result while still leading to a misreading. The standard h:mm format resets to zero after 24 hours. A total of 38 h 30 min will therefore appear as 14:30, throwing off any visual check.

To display a total exceeding one day, the cell format must be set to [h]:mm (with square brackets). This distinction is important on a weekly or monthly timesheet.

Convert in Excel without formatting errors

  • The basic formula is the same as for a manual calculation: whole hours + (minutes / 60). In Excel, a cell formatted as a time stores the duration as a fraction of a day (24 h = 1). To get a decimal value in hours, multiply the cell value by 24.
  • The TRUNC function isolates the whole-hour portion before the decimal fraction is added. ROUND then sets the desired number of decimal places.
  • For a monthly total, use the [h]:mm format in the total cell, then convert that cell into hundredths by multiplying by 24. Round just once, on the final result.

Overhead view of a desk with a timesheet and calculations for converting hours into hundredths

Time records and proof of hours worked: conversion alone is not enough

Converting time into hundredths makes payroll calculations easier, but does not, by itself, prove the hours worked. In a ruling dated April 2, 2025, the Court of Cassation reiterated that employees must provide sufficiently precise evidence of unpaid hours, and that employers must be able to respond with their own records.

A time record expressed in hundredths, without retaining the original clock-in and clock-out times, makes verification difficult. Raw time records must be archived alongside the decimal format.

Time-tracking audit trail

The time-tracking system settings (rounding threshold, break deductions, clocking in to the nearest quarter-hour or minute) determine which minutes are counted. Two companies using the same time clock can produce different totals depending on their settings. Mathematical conversion into hundredths comes afterward: it represents a time total whose counting rules must themselves be documented.

Keeping records in h:mm format alongside the decimal format makes it possible to trace the entire calculation, from clock-in to the payslip line. This dual archiving protects both the employer and the employee in the event of a dispute.

Converting into hundredths remains a simple arithmetic operation (dividing the minutes by 60). What changes the final result is when rounding is applied, the format in which the spreadsheet displays the total, and the settings of the time-tracking system upstream. Getting these three factors right prevents most payroll discrepancies related to working time.

Converting Hours to Hundredths: Simplify Calculations and Optimize Time Management