J Jim Cone Apr 23, 2008 #2 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?
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?
J jhodges Apr 24, 2008 #3 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?
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?
D David Biddulph Apr 24, 2008 #4 You confused us by talking about seconds rather than talking about time. If you have a time, use =CEILING(B1,1/24/60)
You confused us by talking about seconds rather than talking about time. If you have a time, use =CEILING(B1,1/24/60)
J jhodges Apr 24, 2008 #5 David I tried that and I get the same number that I am trying to round up, what am I doing wrong?
D David Biddulph Apr 28, 2008 #7 Glad it helped. -- David Biddulph jhodges said: Thanks David after doing the Paste special/Divide it worked perfectly. Click to expand...
Glad it helped. -- David Biddulph jhodges said: Thanks David after doing the Paste special/Divide it worked perfectly. Click to expand...
