Suppose, you have a list of timestamps of each time a new data entry occurs in your worksheet. Now to analyze the data entry frequency, you want to round off your timestamps to the nearest **15 minutes.** Well, there are several ways to do that. In this article, you will learn **6 quick methods** to round time to the nearest 15 minutes in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the Excel file from the following link and practice along with it.

## 6 Methods to Round Time to Nearest 15 Minutes in Excel

### 1. Using MROUND Function to Round Time to Nearest 15 Minutes

You can **use the MROUND function** to round your time to the resting 15 minutes quite easily.

For that,

âť¶ Insert the following formula in cell **C5**.

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

Here,

- Cell
**B5**contains the sampling timestamp. **â€ś0:15â€ť**specifies that the time interval will be**15 minutes.**

âť· Then press **ENTER**.

âť¸ Drag the **Fill Handle** icon from cell **C5 **to **C12 **to copy the formula.

Now you will see, that all of your times have been rounded off to the nearest 15 minutes.

Here, the **MROUND **function rounds off a time to its nearest multiple of 15 minutes. For example, the multiples of 15 minutes close to **7:10 AM** are **7:00 AM** and **7:15 AM**. Here, **7:15 AM** is the closest to the **7:10 AM** than **7:00 AM**. Thus, **7:10 AM** turns out **7:15 AM** instead of **7:00 AM**.

For the same reason, **8:19 AM** becomes **8:15 AM**, **9:22 AM** becomes **9:15 AM**, and so on.

**Read More: How to Round Time to Nearest Minute in Excel (5 Suitable Ways)**

### 2. Using CEILING Function to Round Time to Next Nearest 15 Minutes

**The CEILING function** **rounds up a number to its next closest integer value**. You can use this function to round off time to the **next nearest 15 minutes **in Excel.

For that,

âť¶ Insert the following formula in cell **C5**.

`=CEILING(B5,"0:15")`

Here,

- Cell
**B5**contains the sampling timestamp. **â€ś0:15â€ť**specifies that the time interval will be**15 minutes.**

âť· Then press **ENTER**.

âť¸ Drag the **Fill Handle** icon from cell **C5 **to **C12 **to copy the formula.

After that, all of your times have been rounded off to the next nearest 15 minutes of the timestamp.

Here, the **CEILING **function rounds off a time to its next nearest multiple of 15 minutes. For example, the multiples of 15 minutes close to **7:10 AM** are **7:00 AM** and **7:15 AM**. Here, **7:15** **AM** is the next closest to the **7:10 AM** whereas, **7:00 AM** is the previous closest.Â Thus, **7:10 AM** turns out **7:15 AM** instead of **7:00 AM**.

For the same reason, **8:19 AM** becomes **8:30 AM**, **9:22 AM** becomes **9:30 AM**, and so on.

**Read More:** **How to Round Time in Excel (With 3 Examples)**

**Similar Readings**

**How to Round a Formula with SUM in Excel (4 Simple Ways)****Round off Formula in Excel Invoice (9 Quick Methods)****How to Round Excel Data to Make Summations Correct (7 Easy Methods)**

### 3. Round Time to Immediate Previous Nearest 15 Minutes Using FLOOR Function

**The FLOOR function** **rounds off a number to its previous nearest integer value**. However, this function can also be used to round off a time its **immediate nearest 15 minutes**.

To do that,

âť¶ First, Insert the following formula in cell **C5**.

`=FLOOR(B5,"0:15")`

Here,

- Cell
**B5**contains the sampling timestamp. **â€ś0:15â€ť**specifies that the time interval will be**15 minutes**.

âť· Then press **ENTER**.

âť¸ Now, drag the **Fill Handle** icon from cell **C5 **to **C12 **to copy the formula.

Finally, you will see that all of your timestamps have been rounded off to their immediate nearest 15 minutes.

Here, the **FLOOR **function rounds off a time to its previous nearest multiple of 15 minutes. For example, the multiples of 15 minutes close to **7:10 AM** are **7:00 AM** and **7:15 AM**. Here, **7:00 AM** is the previous closest to **7:10** AM whereas, **7:15 AM** is the next closest.Â Thus, **7:10 AM** turns out **7:00 AM** instead of **7:15 AM**.

For the same reason, **8:19 AM** becomes **8:15 AM**, **9:22 AM** becomes **9:15 AM**, and so on.

**Read More: Round Time to Nearest 5 Minutes in Excel (4 Quick Methods)**

### 4. Using ROUND Function to Round Time to Nearest 15 Minutes

**The ROUND function** is a general-purpose function to **round **off numbers. However, this function can be used to round off a time value to its nearest 15 minutes in Excel.

To do that,

âť¶ Insert the following formula in cell **C5**.

`= (ROUND((B5*1440)/15, 0)*15)/1440`

Here,

- Cell
**B5**contains the sampling timestamp. - The timestamp is multiplied by
**1440**to convert the time into minutes. - Then it is divided by
**15**to count the chunks of**15**minutes in the timestamp. **0**is used to remove all the digits after the decimal point.- Finally, it is multiplied by
**15**and later divided by**1440**again to round the time to the nearest 15 minutes.

âť· Then press **ENTER**.

âť¸ Drag the **Fill Handle** icon from cell **C5 **to **C12 **to copy the formula.

Now you will see, that all of your times have been rounded off to the nearest 15 minutes.

Here, the **ROUND **function rounds off a time to its nearest multiple of 15 minutes. For example, the multiples of 15 minutes close to **7:10 AM** are **7:00 AM** and **7:15 AM**. Here, **7:15 AM** is the closest to the **7:10 AM** than **7:00 AM**. Thus, **7:10 AM** turns out **7:15 AM** instead of **7:00 AM**.

For the same reason, **8:19 AM** becomes **8:15 AM**, **9:22 AM** becomes **9:15 AM**, and so on.

**Read More:** **Rounding Time to Nearest Quarter Hour in Excel (6 Easy Methods)**

**Similar Readings**

**Rounding to Nearest Dollar in Excel (6 Easy Ways)****Stop Excel from Rounding Large Numbers (3 Easy Methods)****How to Roundup a Formula Result in Excel (4 Easy Methods)**

### 5. MOD Function to Round Time to Immediate Previous Nearest 15 Minutes

Here, I will show you how to round time to the nearest 15 minutes in Excel **using the MOD function****.**

For that,

âť¶ Insert the following formula in cell **C5**.

`=B5-MOD(B5,15/24/60)`

Here,

- Cell
**B5**contains the sampling timestamp. **15/24/60**is the**divisor**.

âť· Then press **ENTER**.

âť¸ Drag the **Fill Handle** icon from cell **C5 **to **C12 **to copy the formula.

Now you will see, that all of your times have been rounded off to the nearest 15 minutes.

Here, the formula of the **MOD** function rounds off a time to its previous nearest multiple of 15 minutes. For example, the multiples of 15 minutes close to** 7:10 AM** are **7:00 AM** and **7:15 AM**. Here, **7:00 AM** is the previous closest to **7:10 AM** whereas, **7:15 AM** is the next closest.Â Thus, **7:10 AM** turns out **7:00 AM** instead of **7:15 AM**.

For the same reason, **8:19 AM** becomes **8:15 AM**, **9:22 AM** becomes **9:15 AM**, and so on.

**Read More: Rounding Time in Excel to Nearest Hour (6 Easy Methods)**

### 6. Using TIME, ROUND, HOUR, and MINUTE Functions to Round Time

In this section, I will show you how to round time to the nearest 15 minutes by combining the **TIME**, **ROUND**, **HOUR**, and **MINUTE **functions in Excel.

For that,

âť¶ Insert the following formula in cell **C5**.

`=TIME(HOUR(B5),ROUND((MINUTE(B5)/60)*4,0)*15,0)`

Here,

- Cell
**B5**contains the sampling timestamp. **HOUR(B5)**extracts hours from cell**B5**.**MINUTE(B5)/60)*4,0)**extracts minutes from cell**B5**.**ROUND((MINUTE(B5)/60)*4,0)**rounds off the value returned by**MINUTE(B5)/60)*4,0).****TIME(HOUR(B5),ROUND((MINUTE(B5)/60)*4,0)*15,0)**converts the fraction number output**HOUR(B5),ROUND((MINUTE(B5)/60)*4,0)*15**into time format.

âť· Then press **ENTER**.

âť¸ Drag the **Fill Handle** icon from cell **C5 **to **C12 **to copy the formula.

Now you will see, that all of your times have been rounded off to the nearest 15 minutes.

Here, the combination of the **TIME**, **ROUND**, **HOUR**, & **MINUTE **functions rounds off a time to its nearest multiple of 15 minutes. For example, the multiples of 15 minutes close to **7:10 AM** are **7:00 AM** and **7:15 AM**. Here, **7:15 AM** is the closest to the **7:10 AM** than **7:00 AM**. Thus, **7:10 AM** turns out **7:15 AM** instead of **7:00 AM**.

For the same reason, **8:19 AM** becomes **8:15 AM**, **9:22 AM** becomes **9:15 AM**, and so on.

**Read More: Round to Nearest 5 or 9 in Excel (8 Easy Methods)**

## Conclusion

To sum up, we have discussed **6 **methods to round time to the nearest 15 minutes in Excel. You are recommended to download the practice workbook attached with this article and practice all the methods. And donâ€™t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website **Exceldemy** to explore more.