This tutorial will demonstrate how to round time in Excel and Google Sheets.
To round time in Excel, you should use the MROUND Function and enter your rounding multiple as a unit of time using quotations.
This example rounded time to the nearest 15 minutes. Instead you could round to the nearest 60 minutes instead.
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.
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.
Round Time Down
To round time down, use the exact same technique except with the FLOOR Function.
Round Time in Google Sheets
All of the above examples work exactly the same in Google Sheets as in Excel.