Rounding Up

N

Neil Greenough

I have cells formatted to time, hh:mm.

What I'd like to do is be able to round up the minutes part of this cell to
the nearest 10 minutes.

So, for example, if the cell has 01:12, this would change to 01:10. If it
had 05:19, this would change to 05:20.

Any ideas?
 
B

Bob Phillips

=ROUND(A1*144,0)/144

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

GSalisbury

Bob,
I, too, say thanks for this.
It was amazingly timely.
I was wanting to do this exact thing and your answer showed up without me
even asking a question.
How great is that!
Geo.
 
Top