|
Featured Tutorial
Featured Macro
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
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