Round Time to Nearest 15 Minutes (or Other Multiple) – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

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

Round time

 

Round Time

To round time in Excel, you should use the MROUND Function, entering your rounding multiple as a unit of time (surrounded by quotations).

=MROUND(B3,"0:15")

Round Time

This example rounded time to the nearest 15 minutes. Instead you could round to the nearest 60 minutes instead.

=MROUND(B3,"0:60")

MRound 60Mints

Another way to enter time is by using decimal values. In Excel, time is stored as decimal values.

For example, 1/24 represents one hour, by entering 1/24 into MROUND, you will round to the nearest hour.

=MROUND(B3,1/24)

MRound 1upon24

Round Time Up

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

=CEILING(B3,"0:15")

Celing

Round Time Down

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

=FLOOR(B3,"0:15")

Floor

Round Time in Google Sheets

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

Round Time Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List