Round Time to the Nearest 15 Minutes in Excel - MROUND Formula

12K views May 16, 2023

In this video, we round time to the nearest 15 minutes in Excel using a formula. In previous videos, we have grouped times using formulas and PivotTables to group the times into ranges. Maybe though you need to round a time to the nearest multiple, instead of rounding it down to be within a range. The MROUND function is used along with the TIME function here to achieve this in the video. We round the time to the nearest 15 minutes, but any multiple can be used. Group times into specific intervals using an Excel formula - https://youtu.be/Osx_aIV_O7I Here are the timings of the video. 00:00 - Introduction to the video 00:58 - MROUND function to round to a specific multiple 01:38 - TIME function used to specify 15 minute interval 02:17 - Demonstration of the formula working 02:55 - Closing words Find more great free tutorials at; https://www.computergaga.com

#Computer Education
#Computers & Electronics
#Educational Software