Are you sure that you've got minutes and seconds, and that you've not got
hours and minutes? Format as hh:mm:ss and then you'll see what you've got.
If you've got hours and minutes when you wanted minutes and seconds, put 60
in a spare cell, copy, select the data that you want to convert, then Edit/
Paste Special/ Divide. If you type in 13:34, it will default to hours and
minutes. If you want minutes and seconds you need to type 0:13:34 or
13:34.0
--
David Biddulph

"jhodges" wrote in message
...
David I tried that and I get the same number that I am trying to round up,
what am I doing wrong?
--
jhodges


"David Biddulph" wrote:

You confused us by talking about seconds rather than talking about time.
If you have a time, use =CEILING(B1,1/24/60)
--
David Biddulph

"jhodges" wrote in message
...
Thanks David but that did not work for me. I am trying to round up
(ex.)
13:34 to 14:00 but I keep getting 24:00. Is it a formating problem
maybe?
--
jhodges


"David Biddulph" wrote:

.... or =CEILING(B1,60) if you still want to see the number as
seconds.
--
David Biddulph

"Jim Cone" wrote in message
...

With the number of seconds in cell B1...
=ROUNDUP(B1/60,0)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"jhodges"
wrote in message
Is there a formula for rounding up seconds to the next highest
minute?
--
jhodges