If you are looking for some special tricks of rounding time in Excel to the nearest quarter-hour, you’ve come to the right place. In Microsoft Excel, there are numerous ways of rounding time in Excel to the nearest quarter-hour. This article will discuss six methods of rounding time in Excel to the nearest quarter-hour. Let’s follow the complete guide to learn all of this.

## Rounding Time to Nearest Quarter Hour in Excel: 6 Easy Ways

In the following section, we will use six effective and tricky methods of rounding time in Excel to the nearest quarter-hour. This section provides extensive details on six methods. You should learn and apply all of these to improve your thinking capability and Excel knowledge.

### 1. Using MROUND Function

Here, we will demonstrate how to round time in Excel to the nearest quarter-hour. Let us first introduce you to our Excel dataset so that you are able to understand what we are trying to accomplish with this article. Here, in the dataset, the details of the exit times for every employee of a company are provided. Now, we want to round time to the nearest quarter-hour by using **the MROUND function**. Let’s walk through the steps to round time in Excel to the nearest quarter-hour.

**📌 Steps:**

- Firstly, we will use the following formula in the cell
**D5:**

`=MROUND(C5,"0:15")`

Here, the **MROUND** function is used to round the time of cell **C5** to the nearest quarter-hour. We set the multiplier to **“0:15”** since quarters equal 0.15.

- Press
**Enter**.

- Next, drag the
**Fill handle**icon**.** - Therefore, you can round time in Excel to the nearest quarter-hour, as shown below.

**Read More: ****Round off Formula in Excel Invoice**

### 2. Applying FLOOR Function

Here, we will show another effective method to round time in Excel to the nearest quarter-hour by using **the FLOOR function**. Let’s walk through the steps to round time in Excel to the nearest quarter-hour.

**📌 Steps:**

- Firstly, we will use the following formula in the cell
**D5:**

`=FLOOR(C5,"00:15")`

Here, the **FLOOR** function is used to round the time of cell **C5** to the nearest quarter-hour. We set the multiplier to **“0:15”** since quarters equal 0.15.

- Press
**Enter**.

- Next, drag the
**Fill handle**icon. - Therefore, you can round time in Excel to the nearest quarter-hour, as shown below.

**Read More: ****How to Remove Decimals in Excel with Rounding**

### 3. Implementing CEILING.MATH Function

Now, we will demonstrate another quickest method to round time in Excel to the nearest quarter-hour by using **the CEILING.MATH function**. Let’s walk through the steps to round time in Excel to the nearest quarter-hour.

**📌 Steps:**

- Firstly, we will use the following formula in the cell
**D5**

`=CEILING.MATH(C5,"00:15")`

Here, the **CEILING.MATH** function is used to round the time of cell **C5** to the nearest quarter-hour. We set the multiplier to **“0:15”** since quarters equal 0.15.

- Press
**Enter**.

- Next, drag the
**Fill handle**icon**.** - Therefore, you can round time in Excel to the nearest quarter-hour, as shown below.

**Read More: ****How to Round to Nearest 10 Cents in Excel**

**Similar Readings**

**How to Roundup a Formula Result in Excel****Rounding to Nearest Dollar in Excel****How to Stop Excel from Rounding Large Numbers**

### 4. Utilizing ROUND Function

By using **the ROUND function** in Excel, we can also quickly round time to the nearest quarter-hour. Let’s walk through the steps to round time in Excel to the nearest quarter-hour.

**📌 Steps:**

- Firstly, we will use the following formula in the cell
**D5:**

`=ROUND(C5*(24*60/15),0)/(24*60/15)`

Here, the **ROUND** function is used to round the time of cell **C5** to the nearest quarter-hour. We multiply **24*60/15 **with the cell value in Excel, since one hour is equal to **1/24**. **Num digits** are set to **0**, as we do not want decimal values. After the whole formula is divided by **24*60/15**, it is converted to the nearest quarter-hour.

- Press
**Enter**.

- Next, drag the
**Fill handle**icon. - Therefore, you can round time in Excel to the nearest quarter-hour, as shown below.

**Read More:** **How to Add ROUND Formula to Multiple Cells in Excel**

### 5. Using Combined Formula

By combining **TIME****, ****HOUR****, ****MINUTE****, ****SECOND****, **and **MROUND** functions in Excel, we can also quickly round time to the nearest quarter-hour. Let’s walk through the steps to round time in Excel to the nearest quarter-hour.

**📌 Steps:**

- Firstly, we will use the following formula in the cell
**D5:**

`=TIME(HOUR(C5),MROUND(MINUTE(C5)+SECOND(C5)/60,15),0)`

- Then, press
**Enter**.

- Next, drag the
**Fill handle**icon. - Therefore, you can round time in Excel to the nearest quarter-hour, as shown below.

**🔎 How Does the Formula Work? **

- With the help of the
**TIME**function, we present the time of cell**C5**with hours, minutes, and seconds. - We set
**minute**and**second**to 0 since want the nearest quarter-hour. - Then, we use the
**MROUND**function, multiply the formula by 60, and set the multiplier as 15 to round the time of cell**C5**to the nearest quarter-hour. - Finally, we get the output time of
**3:15 PM**in cell**D5**.

**Read More: ****Round to Nearest 5 or 9 in Excel**

### 6. Implementing Nested IF Formula in Excel

By using **the IF function** in Excel, we can also quickly round time to the nearest quarter-hour. Here, we also use **HOUR** and **MINUTE** functions. Let’s walk through the steps to round time in Excel to the nearest quarter-hour.

**📌 Steps:**

- Firstly, select the range of cell
**D5:F13**and select**General**to maintain a proper format of the cell.

- Next, we will use the following formula in the cell
**D5:**

`=HOUR(C5)`

Here, the **HOUR** function returns the hour as a number from cell **C5**.

- Then, press
**Enter**.

- Next, drag the
**Fill handle**icon. - Therefore, you can get the
**Hour**column, as shown below.

- Next, we will use the following formula in the cell
**E5:**

`=MINUTE(C5)`

Here, the **MINUTE **function returns the minute as a number from cell **C5**.

- Then, press
**Enter**.

- Next, drag the
**Fill handle**icon. - Therefore, you can get the
**Minutes**column, as shown below.

- Next, we will use the following formula in the cell
**F5:**

`=IF(E5<8,0,IF(E5<23,15,IF(E5<38,30,IF(E5<53,45,60))))`

Here, the IF function tests whether the conditions are met or not, and returns a value accordingly.

- Then, press
**Enter**.

- Next, drag the
**Fill handle**icon. - Therefore, you can round time in Excel to the nearest quarter-hour, as shown below.

**Read More: ****How to Round to Nearest Whole Number in Excel**

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

## Conclusion

That’s the end of today’s session. I strongly believe that from now you may round time in Excel to the nearest quarter-hour. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!

## Related Articles

**How to Set Decimal Places in Excel with Formula****How to Round Down to Nearest Whole Number in Excel****How to Round Numbers to the Nearest Multiple of 5 in Excel****Excel VBA: Round to Nearest 5****Round Down to Nearest 10 in Excel****How to Round to Nearest 100 in Excel****How to Round Numbers to Nearest 10000 in Excel****How to Round a Formula with SUM in Excel****How to Round up Decimals in Excel****How to Round Up to 2 Decimal Places in Excel****How to Get 2 Decimal Places Without Rounding in Excel****How to Round Percentages in Excel****How to Set Rounding Precision in Excel****How to Round Time in Excel****How to Round Time to Nearest Minute in Excel****Round Time to Nearest 5 Minutes in Excel****How to Round Time to Nearest 15 Minutes in Excel****Rounding Time in Excel to Nearest Hour****How to Round Off to Nearest 50 Cents in Excel****How to Round Excel Data to Make Summations Correct****How to Stop Rounding in Excel****How to Remove Decimals without Rounding in Excel****How to Stop Excel from Rounding Up Decimals****How to Round a Multiplication Formula in Excel****How to Round Numbers in Excel Without Formula**