Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...

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.