J
jhodges
Is there a formula for rounding up seconds to the next highest minute?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Cone
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?
=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?
D
David Biddulph
.... or =CEILING(B1,60) if you still want to see the number as seconds.
J
jhodges
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?
13:34 to 14:00 but I keep getting 24:00. Is it a formating problem maybe?
D
David Biddulph
You confused us by talking about seconds rather than talking about time.
If you have a time, use =CEILING(B1,1/24/60)
If you have a time, use =CEILING(B1,1/24/60)
J
jhodges
David I tried that and I get the same number that I am trying to round up,
what am I doing wrong?
what am I doing wrong?
D
David Biddulph
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
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
J
jhodges
Thanks David after doing the Paste special/Divide it worked perfectly.
D
David Biddulph
Glad it helped.
--
David Biddulph
--
David Biddulph
jhodges said:Thanks David after doing the Paste special/Divide it worked perfectly.