Skip to content

Convert Hours to Hundredths: A Simple Way to Manage Your Time Better

On a payslip, 7 hours and 20 minutes of work is written as 7.33, not 7.20. Confusing the two means shortchanging your pay…

Femme professionnelle calculant des heures en centièmes sur une feuille de temps à son bureau

On a payslip, 7 h 20 of work is written as 7.33, not 7.20. Confusing the two means shortchanging an employee by several minutes a day.

Converting hours into hundredths involves moving from base 60 (minutes) to base 10 (decimal format), and this calculation is essential to the accuracy of the entire payroll process. Here, we explain how the calculation works, the pitfalls of rounding errors that accumulate over a month, and how to keep monthly timesheets consistent.

Rounding discrepancies on a monthly timesheet: the pitfall spreadsheets don’t show

Most guides to converting hours into hundredths stop at the formula and conversion table. The real problem starts when you add up days that have already been rounded individually.

Let’s look at a practical example. An employee clocks 7 h 10 each day. The exact conversion is 7.1667 h. If the software or spreadsheet rounds to two decimal places, that becomes 7.17 h per day. Over a five-day week, the rounded total is 35.85 h, while the actual total (5 x 7.1667) is 35.8333 h. The difference between rounding each day and using the actual total amounts to several hundredths of an hour per week.

Over a full month, this discrepancy can result in a noticeable overpayment or underpayment on the payslip. The problem gets worse when daily hours vary: 7 h 10 one day, 8 h 50 the next, and 6 h 40 on another. Each individual rounding pushes the total in a different direction.

There are two ways to ensure a reliable monthly timesheet. The first is to convert hours into hundredths using at least four decimal places for each time entry, then round only once, on the monthly total. The second is to add all durations in hours and minutes (base 60), then convert the final total into hundredths. Both approaches prevent intermediate rounding errors from accumulating.

Man standing in front of a whiteboard explaining how to convert hours into hundredths in a meeting room

Converting hours and minutes into hundredths: how the base-10 calculation works

The calculation takes one step: divide the number of minutes by 60, then add the result to the whole hours. For 8 h 45, divide 45 by 60 to get 0.75. The time in decimal format is therefore 8.75 h.

The most common mistake is to write 8.45 instead of 8.75. This confusion comes from the instinct to place the minutes directly after the decimal point, as if they were cents. In base 60, 45 minutes is three-quarters of an hour, not 45 hundredths.

Key conversions to remember

Some values come up frequently when tracking working hours and are worth memorizing rather than recalculating:

  • 15 minutes is 0.25 h, exactly a quarter of an hour in decimal format.
  • 30 minutes is 0.50 h, or half an hour.
  • 45 minutes is 0.75 h, or three-quarters of an hour.
  • 10 minutes is 0.1667 h (commonly rounded to 0.17 h).
  • 20 minutes is 0.3333 h (commonly rounded to 0.33 h).

Multiples of 15 convert neatly. Durations that are not multiples of 15 produce repeating decimals, which is precisely where rounding becomes an issue.

Calculating hundredths in a spreadsheet: how to avoid formatting errors

In a spreadsheet, the cell display format makes all the difference. A cell formatted as a time (hh:mm) stores the duration as a fraction of a 24-hour day, not as a decimal number. If you add cells formatted as times and then copy the result into a cell formatted as a number, the displayed value will have nothing to do with the total in hundredths.

The reliable method is to enter the hours and minutes in two separate columns (one for “hours” and one for “minutes”), then apply the formula in a third column: hours + (minutes / 60). The result appears directly in decimal format, ready for payroll.

Round the final total, not each day

As we saw above, rounding each daily entry to two decimal places and then adding the entries produces a slightly inaccurate total. Rounding should happen only once, on the monthly total. In a spreadsheet, this means keeping all decimal places in the daily column (number format with at least four decimal places) and using a rounding function to two decimal places only in the monthly total cell.

Whether to round up or down to the nearest hundredth depends on the collective bargaining agreement or the company’s internal policy. Some payroll software rounds to the nearest half-hundredth, which reduces the discrepancy even further.

Desk view with a smartphone calculator for converting hours into hundredths and handwritten conversion notes

Quick conversion table for payroll

A summary table is still useful for checking a mental calculation or spotting a data-entry error. Here are the most common values in a professional setting:

Minutes Hundredths
5 0,08
10 0,17
15 0,25
20 0,33
25 0,42
30 0,50
35 0,58
40 0,67
45 0,75
50 0,83
55 0,92

These values are rounded to two decimal places. For accurate time tracking over a full month, retaining the third or fourth decimal place in intermediate calculations is the only way to ensure a reliable total.

Converting hours into hundredths is not just a theoretical exercise: this is the format used by payroll software, social security filings, and most time-tracking tools. Learning the formula takes just a few seconds. Knowing where to round—once at the end of the month rather than line by line—is what makes the difference between an accurate timesheet and one that drifts by a few minutes each pay period.

Convert Hours to Hundredths: A Simple Way to Manage Your Time Better