| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Roundup time
Is there a formula for rounding up seconds to the next highest minute?
-- jhodges |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| roundup by 16s | Excel Worksheet Functions | |||
| time questions (roundup & convert hh to mm | Excel Discussion (Misc queries) | |||
| ROUNDUP | Excel Discussion (Misc queries) | |||
| How can I roundup to next 0 i.e. 71 to 80? | Excel Worksheet Functions | |||
| Roundup | Excel Worksheet Functions | |||
Linear Mode
