Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to round a time to the nearest 15 minutes in Excel and Google Sheets
Topic:Rounding & number formattingExcel & Google Sheets
=MROUND(A2,"0:15")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Raw Time | Rounded 15 min |
| 9:07 AM | |
| 10:23 AM | |
| 2:38 PM | |
| 4:52 PM |
=MROUND(A2,"0:15")→0.375
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter time values in column A (formatted as Time).
- 2In B2 enter =MROUND(A2,"0:15") — Excel and Sheets both accept time strings as the multiple.
- 3Alternatively use the numeric form: =MROUND(A2,15/1440) since there are 1440 minutes in a day.
- 4Format column B as Time to display HH:MM.
Tips
- To always round UP to the next 15 minutes (like billing), use =CEILING(A2,"0:15"). To always round DOWN, use =FLOOR(A2,"0:15").
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
What is 15/1440 in the formula?
Excel stores time as a fraction of 24 hours. 15 minutes = 15/60/24 = 15/1440 of a day. Using "0:15" as a string is equivalent and easier to read.
Can I round to 30-minute intervals?
Yes — use =MROUND(A2,"0:30") or =MROUND(A2,30/1440).