# Round Time to Nearest 15 Minutes (or other multiple) – Excel & Google Sheets

This tutorial will demonstrate how to round time in Excel and Google Sheets. ## Round Time

To round time in Excel, you should use the MROUND Function and enter your rounding multiple as a unit of time using quotations.

`=MROUND(B3,"0:15")` This example rounded time to the nearest 15 minutes. Instead you could round to the nearest 60 minutes instead.

`=MROUND(B3,"0:60")` If you don’t want to enter time in this fashion, you can enter a decimal value corresponding to a unit of time.  For example 1/24 represents one hour, by entering 1/24 into MROUND, you will round to the nearest hour.

`=MROUND(B3,1/24)` This works because in Excel, time is stored as a decimal value where a whole day equals 1 and each 1/24 represents one hour of the day.

## Round Time Up

To round time up, use the exact same technique except with the CEILING Function.

`=CEILING(B3,"0:15")` ## Round Time Down

To round time down, use the exact same technique except with the FLOOR Function.

`=FLOOR(B3,"0:15")` ## Round Time in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel. 