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