Rounding Times in MS Excel

There are many different reasons why you might want to round numbers in different applications within MS Excel. Sometimes it is very useful to round times to the nearest hour, half-hour or quarter-hour.

The Analysis TookPack add-in module has a function that is very useful for this. It is called MROUND. If you are not familiar with the Analysis TookPack, click on Tools| Add-ins and check Analysis ToolPack.

Enter a time in A1. In B1, enter the number of minutes to which you want to round the time. Say you want to round to the nearest half-hour, you would use the formula below:

• =TIME(HOUR(A1), MROUND(MINUTE(A1), B1),0)

I bet you have thought of a couple of uses for this already!

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!