What it does
=MROUND(B2,5) rounds B2 to the nearest multiple of 5: 15 for 17, 20 for 18. Values exactly halfway (such as 17.5) are rounded up, away from zero. The multiple can have decimals: =MROUND(B2,0.05) rounds a price to steps of 5 cents.
Because times are stored as fractions of a day, it works for clock times too: 15 minutes is 1/96 of a day, and =MROUND(B2,1/96) rounds clock-in and clock-out times to the nearest quarter hour. Give the result cell a time format.
The number and the multiple must have the same sign; rounding a negative number with a positive multiple returns #NUM!. To always round up or down use CEILING.MATH and FLOOR.MATH; to round by digits use ROUND.
Syntax
=MROUND(number, multiple)=KYUVARLA(sayı; katsayı)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The number or time to round. |
multiple | Required | The value the result should be a multiple of: 5, 0.05, or 1/96 for 15 minutes. It must have the same sign as number; with 0 the result is 0. |
Examples
1Round a price to 5 cents and to 5 units
Column C rounds the price to the nearest multiple of 0.05 and column D to the nearest multiple of 5. Rounding can go either way; the nearest multiple decides.
=MROUND(B2,0.05)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Calculated Price | To 5 Cents | To 5 Units |
| 2 | Bagel | 17.43 | 17.45 | 15 |
| 3 | Scone | 23.16 | 23.15 | 25 |
| 4 | Pie | 62.50 | 62.50 | 65 |
| 5 | Cake | 147.80 | 147.80 | 150 |
- C2 (filled down to C5)
=MROUND(B2,0.05) - D2 (filled down to D5)
=MROUND(B2,5)
The bagel's price becomes 17.45 rounded to 5 cents and 15 rounded to 5 units. The pie sits exactly halfway between 60 and 65, so it is rounded up: 65.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Round clock-in and clock-out times to the quarter hour
15 minutes is 1/96 of a day. Columns D and E round the clock-in and clock-out times to the nearest multiple of that; the result cells use a time format.
=MROUND(B2,1/96)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Employee | In | Out | In (Rounded) | Out (Rounded) |
| 2 | Emma | 08:07 | 17:38 | 08:00 | 17:45 |
| 3 | Liam | 08:23 | 17:52 | 08:30 | 17:45 |
| 4 | Olivia | 08:52 | 18:06 | 08:45 | 18:00 |
- D2 (filled down to D4)
=MROUND(B2,1/96) - E2 (filled down to E4)
=MROUND(C2,1/96)
Emma's times are recorded as 08:00 in and 17:45 out; Liam's 08:23 arrival goes to the next quarter, 08:30. Without a time format, these cells would show numbers such as 0.333333.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- #NUM!
Cause: number and multiple have different signs, e.g.
MROUND(-17,5).Fix: Give both the same sign:
MROUND(-17,-5)returns -15.- Time shows as a number
Cause: The time was rounded, but the cell shows a number such as 0.333333.
Fix: Apply an
hh:mmtime format to the result cell.- Halfway value went the other way
Cause: With decimal multiples, floating-point differences can send an exactly halfway value the other way (e.g. 0.725 to a multiple of 0.05).
Fix: For such borderline values, round the number to a few decimals with ROUND first.
Good to know
- To get prices ending in .90, round to the nearest 10 and subtract 0.10:
=MROUND(B2,10)-0.1. - For half an hour the multiple is
1/48; for 5 minutes it is1/288.
In Nexell
Get Nexell to do it from a sentence
Add two columns to the timesheet that round the clock-in and clock-out times to the nearest quarter hour
Convert to tableBring your timesheet into the tool and type this. Nexell adds both columns with real Excel formulas and shows them in the preview; in the downloaded file, the rounded time changes when a time does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I round a time to the nearest quarter hour in Excel?
Use =MROUND(B2,1/96) and give the cell a time format. To always round up use =CEILING.MATH(B2,1/96), and to round down use =FLOOR.MATH(B2,1/96).