# How to round billable time up to the nearest tenth of an hour in Excel

Convert minutes to hours and round up to one decimal: `=ROUNDUP(B2/60,1)`. Every started 6 minutes bills as 0.1 hour.

**Excel:** `=ROUNDUP(B2/60,1)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C |
| --- | --- | --- |
| Matter | Minutes | Billed hours |
| Call with client | 7 |  |
| Email review | 12 |  |
| Contract edits | 13 |  |
| Meeting | 45 |  |
| Research | 61 |  |
| Filing | 30 |  |

Formula in C2, filled to C7: `=ROUNDUP(B2/60,1)`

Result: 0.2; 0.2; 0.3; 0.8; 1.1; 0.5

## How it works

`B2/60` turns minutes into hours, and `ROUNDUP(…,1)` rounds up to one decimal place, a tenth of an hour, or 6 minutes. A 13-minute task is 0.217 hours and bills as 0.3.

## Other ways

- `=CEILING(B2/60,0.1)`: The same with CEILING; change 0.1 to 0.25 for quarter-hour billing.
- `=ROUND(B2/60,1)`: The nearest tenth instead of always up. (Rounds to the nearest tenth.)

## Common mistakes

- Minutes calculated from times can come out as 12.0000001, which ROUNDUP bills as 0.3. Round the minutes first: `=ROUNDUP(ROUND(B2,0)/60,1)`.
- Check the engagement terms: some firms bill a minimum of 0.2 or 0.25 hours.

## Questions

**How do I round up to the next 15 minutes?**

`=CEILING(B2/60,0.25)`.

**How do I get the minutes from start and end times?**

`=(end-start)*1440`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/round-billable-time-up-to-a-tenth-of-an-hour