rounding to nearest five minutes

[TS Mathews]

I'm a total newby with trying to use Excel (or any spreadsheet for that
matter) and I need a simpy rounding process but can only find things for
rounding to 15 minute intervals or else always rounding up or down. Is
there a formula to simply round :02 down to :00 and :03 up to :05?

I apologize if this is right under my nose and I'm just too stupid to find
it. ;-)

Tim

 

[JE McGimpsey]

One way:

XL stores times as fractional days, and there are 288 5-minute periods
in a day, so:

=ROUND(A1*288,0)/288

Format as time if necessary

 

[TS Mathews]

Much thanks...I knew it had to be WAY easier that all the IF THEN's I was
trying to string together!! ;-)