Excel Forum

Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Great trick from shg at Mr Excel Message Board to Round to 5 Minutes for Integer Values, Not Time Values using ROUND or MROUND functions.
See how to:
1. Round Time Values to 5 Minutes
2. Round Integer Values (Unit = Hour) to 5 minutes

Got a Question? Ask it Here in the Forum.