Excel Forum
Similar Content
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...
Convert Time to Minutes and Vice Versa in Excel
Tutorial: How to convert a time into minutes in Excel and also how to get minutes back into a time f...



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.