round up or down time by 5 mins in excel

**janger-heli** · 05-07-2009, 12:48 PM

I am trying to round up or down in excel to the nearest 5 mins , but with no joy

ie 05:24 = 05:25
06:21 = 06:20

Can anyone help !!!

**NBVC** · 05-07-2009, 12:53 PM

Using Analysis Toolpak function:

=MROUND(A1,TIME(0,5,0))

**NBVC** · 05-07-2009, 12:55 PM

Or without ATP

=ROUND(A1/TIME(0,5,0),0)*TIME(0,5,0)

**janger-heli** · 05-07-2009, 01:03 PM

Originally Posted by NBVC

Or without ATP

=ROUND(A1/TIME(0,5,0),0)*TIME(0,5,0)

Great , works a treat .. thank you

**NBVC** · 05-07-2009, 01:08 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save