Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Thermometer Chart in Excel
  • Subtotal function in Excel
  • Example of COUNTIFS with variable table column in Excel
  • How to create running total in an Excel Table
  • Everything about Charts in Excel

References

  • How to use Excel LOOKUP Function
  • Last row number in range
  • How to use Excel MATCH Function
  • How to get first row number in range in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation date in specific year
  • Excel Data validation with conditional list
  • Excel Data validation don’t exceed total
  • Excel Data validation must begin with
  • Excel Data validation must contain specific text

Round time to nearest 15 minutes in Excel

by

This tutorials shows how to Round time to nearest 15 minutes in Excel.

To round a time to the nearest 15 minute interval, you can use the MROUND function, which rounds based on a supplied multiple.

Formula

=MROUND(time,"0:15")

Explanation

In the example shown, the formula in C6 is:

=MROUND(B6,"0:15")

How this formula works

MROUND rounds to nearest values based on a supplied multiple.  When you supply “0:15” as the multiple, Excel internal converts 0:15 into 0.0104166666666667, which is the decimal value that represents 15 minutes, and rounds using that value.

You can also express 15 minutes in a formula with this formula:

=15/(60*24)

The formula above divides 15 by 1440, which is the number of minutes in one day. So, to Excel, these formulas are identical:

=MROUND(B6,"0:15")
=MROUND(B6,15/(60*24))

Round to other time intervals

As you would expect, you can use the same formula to round to different time intervals. To round to the nearest 30 minutes, or nearest 1 hour, use these formulas

=MROUND(time,"0:30") //nearest 30 minutes
=MROUND(time,"1:00") //nearest 1 hour

Always round up

To always round up to the nearest 15 minutes, you can use the CEILING function:

=CEILING(B6,"0:15")

Like MROUND, the CEILING function rounds to a nearest multiple. The difference is that CEILING always rounds up. The FLOOR function can be used to always round down

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Excel If, Nested If, And/Or Criteria Examples
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function
  • Not Equal To ‘<>‘ operator in Excel
  • How to use Excel OR Function

Date Time

  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Basic Overtime Calculation Formula in Excel
  • Calculate days remaining in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Convert Excel time to decimal minutes

Grouping

  • How to randomly assign data to groups in Excel
  • Running count group by n size in Excel
  • Calculate conditional mode with criteria in Excel
  • Map text to numbers in Excel
  • Categorize text with keywords in Excel

General

  • Count cells that do not contain errors in Excel
  • Flash Fill in Excel
  • How to get Excel workbook path only
  • Common Errors in Excel
  • Subtotal by invoice number in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning