Excel Formulas to Round Time to the Nearest 15 Minutes!!

Many of the ways available for rounding the values, such as rounding to integer, fraction, and so on. Microsoft Excel provides a handful of functions to handle different type rounding types. In this article, we will show the formula to round time to the nearest 15 minutes in Excel. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• If you want to round up the time to the nearest 15 minutes, use the below formula.

=MROUND(time,”0:15″)

Syntax Explanations:

• MROUND – The MROUND function will help to return a number rounded to the given multiple.
• Time – It represents the input values from your worksheet.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

• First, we will enter the input times in Column B.
• Here, we need to round up the times to the nearest 15 minutes.

• So, apply the above-given formula to the formula bar section and press the ENTER key.

• Finally, we will get the result in the selected cell as shown in the below image.

Bottom-Line:

From this guide, you can get some clarification on how to round the time to the nearest 15 minutes in Excel. Please share your feedback in the below comment box. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **

Read Also:

• Excel Formulas to Round a Number Up to Next Half Value!!
• Formulas to Round the Values by Bundle Size ~ A Complete Guide!!
• Excel Formulas to Rank Items with One or more Criteria!!