How to Add Decimal Hours

The basic rule for adding decimal hours

Once your values are in decimal-hour format, the calculation is straightforward.

1. Make sure every entry is genuinely in decimal hours.
2. Add the values as ordinary decimal numbers.
3. Keep the required level of precision.
4. Convert the decimal part of the final total back into minutes if needed.

For example:

3.50 + 2.25 = 5.75 hours

0.75 × 60 = 45 minutes

So 5.75 hours = 5h45m.

Decimal hours carry at 1.00, not 0.60

This is one of the most important differences between decimal-hour arithmetic and normal hours-and-minutes arithmetic.

With clock time, 60 minutes = 1 hour. With decimal hours, however, you are adding ordinary decimal numbers, and the next whole hour is reached at 1.00, not 0.60.

For example:

0.75 + 0.50 = 1.25 hours

0.25 × 60 = 15 minutes

So 1.25 hours = 1h15m.

A common mistake is to assume 0.60 hours = 1 hour. It does not:

0.60 × 60 = 36 minutes

So 0.60 hours = 36 minutes, while 1.00 hour = 60 minutes.

Example: adding decimal hours across a whole hour

Suppose you add 3.75 + 2.50. The answer is 6.25 hours.

The decimal parts are:

0.75 + 0.50 = 1.25

That contributes 1 whole hour + 0.25 hour, and 0.25 × 60 = 15 minutes.

So 6.25 hours = 6h15m.

There is no special time-based carrying rule once the values are decimals. Normal decimal arithmetic handles it for you.

Decimal hours vs hours-and-minutes addition

The same time can be added in either format, but the arithmetic is different.

Suppose you want to add 7h30m + 2h45m.

Adding as hours and minutes

30m + 45m = 75m, which becomes 1h15m

7h + 2h + 1h15m = 10h15m

Adding as decimal hours

First convert: 7h30m = 7.50 and 2h45m = 2.75. Then:

7.50 + 2.75 = 10.25 hours

0.25 × 60 = 15 minutes

So 10.25 hours = 10h15m. The answer is the same; the difference is the format used for the calculation.

7:30 + 2:45 must not be treated as 7.30 + 2.45.

Only add genuine decimal-hour values

Before adding any values, check the notation.

Decimal-hour value

7.50 is a number and can be added normally.

Hours-and-minutes value

7:30 means 7 hours 30 minutes. It needs to be added using normal time arithmetic or converted first.

A useful rule is: a colon and a decimal point are not interchangeable.

For example, 7:30 = 7.50 decimal hours, while 7.30 decimal hours = 7h18m.

How to add several decimal-hour entries

Suppose a weekly timesheet already contains decimal-hour values:

Add them:

7.50 + 8.25 + 7.75 + 6.50 + 7.25 = 37.25 hours

Now convert the decimal part:

0.25 × 60 = 15 minutes

So 37.25 hours = 37h15m.

This is one reason decimal hours are useful for payroll, billing and timesheet totals.

Decimal-hour totals can be more than 24 hours

A decimal-hour total represents a duration, not a time of day. That means there is nothing unusual about a result greater than 24 hours.

For example, 38.75 hours is a valid total. Convert the decimal part:

0.75 × 60 = 45 minutes

So 38.75 hours = 38h45m.

The total does not reset after 24 hours. A weekly total such as 37.50 hours or 40.25 hours is simply a duration.

How to convert the final total back to hours and minutes

Take the whole-number part as the hours, then multiply the decimal part by 60.

For example, 26.40 hours: the whole hours are 26 and the decimal part is 0.40.

0.40 × 60 = 24 minutes

So 26.40 hours = 26h24m, not 26h40m.

This is why the decimal part should never be read directly as clock minutes.

37.75 hours does not mean 37 hours 75 minutes

Suppose your total is 37.75 hours. The whole-number part is 37 hours and the decimal part is 0.75 hour.

0.75 × 60 = 45 minutes

Therefore 37.75 hours = 37h45m.

The digits after the decimal point represent a fraction of an hour, not a number of minutes.

Should you add first or convert first?

It depends on what information you already have.

If the entries are already official decimal values

Add them as supplied, for example 7.50 + 7.75 + 8.25. There is no need to convert them back into hours and minutes first.

If you still have the original hours and minutes

Where possible, preserve the original time until you have calculated the total.

This can reduce rounding errors when individual entries do not convert neatly into short decimals.

How rounding can change the total

Suppose you have three separate entries of 20 minutes.

20m + 20m + 20m = 60 minutes = 1.00 hour

But each 20-minute entry is exactly 0.3333… hours. If each one is rounded to two decimal places first:

0.33 + 0.33 + 0.33 = 0.99 hours

That is slightly less than the true total, so rounding each entry before adding can change the final answer.

Where possible, keep the original time or a sufficiently precise value until the final total has been calculated.

Rounding can increase a total too

Rounding does not always reduce the answer.

Suppose there are four entries of 15 minutes. The actual total is:

15m × 4 = 60 minutes = 1.00 hour

But 15 minutes equals 0.25 hours. If each entry were rounded to the nearest tenth, 0.25 becomes 0.3, and:

0.3 × 4 = 1.2 hours = 1h12m

That is 12 minutes more than the original hour.

This is why rounding rules should be applied consistently and at the correct stage of the calculation.

Can you mix tenths and hundredths?

Yes, mathematically.

7.5 + 2.25 = 9.75

because 7.5 = 7.50. The number of visible decimal places does not change the underlying value.

However, a payroll, timesheet or reporting system may require values to be displayed consistently, such as 7.50 rather than 7.5.

For more on this, see Tenths vs Hundredths of an Hour.

Adding decimal hours in a spreadsheet

If a spreadsheet cell contains a genuine numeric decimal-hour value such as 7.50, 8.25 or 6.75, those values can be added like ordinary numbers.

7.50 + 8.25 + 6.75 = 22.50

But a cell containing 07:30 may be stored as a spreadsheet time value rather than the decimal number 7.50.

The two formats should not be treated as interchangeable without conversion.

Decimal hours and pay

Decimal totals are useful because they can be multiplied directly by an hourly rate.

Suppose a weekly total is 37.25 hours and the hourly rate is £15:

37.25 × £15 = £558.75

This is much easier than trying to calculate pay directly from a mixture of hours and minutes.

For more detail, see Decimal Hours for Payroll Explained.

Common mistakes when adding decimal hours

Adding 7:30 as though it were 7.30

7:30 is hours-and-minutes notation. As a decimal it is 7.50.

Carrying at 0.60

Decimal hours carry at 1.00, not 0.60.

Thinking 0.60 means 60 minutes

It means 36 minutes.

Reading 37.75 as 37h75m

It means 37h45m.

Mixing HH:MM and decimal values

Convert them into the same format before calculating.

Rounding every entry too early

This can make the total higher or lower than the original time.

Repeatedly converting rounded values

Each conversion can introduce more rounding. Where possible, keep the original time.

Assuming a total cannot exceed 24 hours

Decimal-hour totals are durations, so weekly and pay-period totals can easily exceed 24 hours.

Confusing spreadsheet time values with decimal numbers

07:30 and 7.50 may represent the same duration, but a spreadsheet may store them very differently.