|
Roundup time
Is there a formula for rounding up seconds to the next highest minute?
-- jhodges |
Roundup time
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 |
Roundup time
.... 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 |
Roundup time
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 |
Roundup time
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 |
Roundup time
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 |
Roundup time
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 |
Roundup time
Thanks David after doing the Paste special/Divide it worked perfectly.
-- jhodges "David Biddulph" wrote: 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 |
Roundup time
Glad it helped.
-- David Biddulph "jhodges" wrote in message ... Thanks David after doing the Paste special/Divide it worked perfectly. -- jhodges "David Biddulph" wrote: 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 |
| All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com