Function Problems

How to Round Excel Times to 15-Minute Intervals

Maira Mehtab Sep 20, 2026 868 views

Question details

A user needs to round time entries in a time-management tracker to 15-minute intervals based on custom boundary rules.

Product: Excel
Device & OS: not provided
Scenario: Calculating customized timesheets where specific minutes dictate the rounding (e.g., minutes 6-19 round to 15, minutes 20-35 round to 30).
Observed behavior: The goal is to accurately calculate and display rounded time values (such as h:mm) using a custom offset for the rounding boundaries.

Before you start

Ensure your source cells are formatted as standard Time values, otherwise the time calculation formulas may return errors or incorrect decimal numbers.

Solution 1Recommended

Use the MROUND and TIME Functions

By combining the MROUND function with a time offset using the TIME function, you can adjust the rounding boundaries to match your custom 15-minute interval rules.

The standard MROUND function rounds to the nearest specified multiple. Because your rules shift the standard halfway points, adding a 3-minute offset before rounding perfectly aligns the logic with your required intervals.

Select the target cell

Click on the cell where you want the rounded time result to appear.

Enter the rounding formula

Type the formula `=MROUND(A2+TIME(0,3,0),TIME(0,15,0))` into the formula bar, replacing 'A2' with the reference to your original time cell.

Apply the formula

Press the Enter key to calculate the result.

Format the result as Time

Right-click the result cell, select 'Format Cells', navigate to the 'Time' category, and choose a format like 'h:mm' to display the result properly.

Custom Offset Explained: Adding TIME(0,3,0) shifts the time forward by 3 minutes before applying the standard MROUND logic. This ensures that minutes 6 through 19 accurately snap to the 15-minute mark.

Advanced Time Calculations Made Easy

Manage Timesheets Effortlessly in WPS Spreadsheet

WPS Spreadsheet provides full support for advanced time and date functions like MROUND, making timesheet management and payroll calculation highly efficient.

1. Open your timesheet: Launch WPS Spreadsheet and open your time-management tracker.
2. Apply the MROUND formula: Enter `=MROUND(A2+TIME(0,3,0),TIME(0,15,0))` in the designated target cell.
3. Format and fill: Format the cell as Time (h:mm) using the Cell Format dialog, then drag the fill handle down to apply it to your entire column.

100% compatible with Microsoft Excel formulas and formattingBuilt-in timesheet templates for quick time trackingRobust data calculation capabilities for complex logicFree and lightweight spreadsheet solution

Frequently Asked Questions

Can I round to the nearest 30 minutes instead?

Yes, you can adjust the formula by changing the second TIME argument. Use `=MROUND(A2+TIME(0,3,0),TIME(0,30,0))` to round to 30-minute intervals.

Why does my formula result show a decimal like 0.625?

Excel stores times as fractional days. If you see a decimal, the cell is formatted as General or Number. Right-click the cell, select 'Format Cells', and change the format to 'Time' (h:mm).

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

If you strictly want to round up rather than rounding to the nearest interval based on custom boundaries, use the CEILING function: `=CEILING(A2, TIME(0,15,0))`.

Excel & Data Problems