| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up time
Hi there
I have a cell that has a formala that calculates the time spent at a port by subtracting the arrival time from the departure time. I want the same cell to always round the time up to the next hour, ei - if there for 2 hours and 10 minutes-- I want it to say 3 hours. As that is how we are charge. Is there a way to do this? If so, how? -- Thank-you! Ruth |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up time
=ROUNDUP(F1*24,0)/24
-- __________________________________ HTH Bob "Ruth" wrote in message ... Hi there I have a cell that has a formala that calculates the time spent at a port by subtracting the arrival time from the departure time. I want the same cell to always round the time up to the next hour, ei - if there for 2 hours and 10 minutes-- I want it to say 3 hours. As that is how we are charge. Is there a way to do this? If so, how? -- Thank-you! Ruth |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up time
You could also use
=CEILING(F1,--"1:00") -- __________________________________ HTH Bob "Ruth" wrote in message ... Hi there I have a cell that has a formala that calculates the time spent at a port by subtracting the arrival time from the departure time. I want the same cell to always round the time up to the next hour, ei - if there for 2 hours and 10 minutes-- I want it to say 3 hours. As that is how we are charge. Is there a way to do this? If so, how? -- Thank-you! Ruth |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up time
Don't even need the --
=CEILING(F1,"1:00") -- __________________________________ HTH Bob "Ruth" wrote in message ... Hi there I have a cell that has a formala that calculates the time spent at a port by subtracting the arrival time from the departure time. I want the same cell to always round the time up to the next hour, ei - if there for 2 hours and 10 minutes-- I want it to say 3 hours. As that is how we are charge. Is there a way to do this? If so, how? -- Thank-you! Ruth |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up time
Hi,
Try this =ROUNDUP((B1-A1)*24,0)/24 A1=Earlier time Mike "Ruth" wrote: Hi there I have a cell that has a formala that calculates the time spent at a port by subtracting the arrival time from the departure time. I want the same cell to always round the time up to the next hour, ei - if there for 2 hours and 10 minutes-- I want it to say 3 hours. As that is how we are charge. Is there a way to do this? If so, how? -- Thank-you! Ruth |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up time
Thank-you - all 3 methods worked.
-- Thank-you! Ruth "Mike H" wrote: Hi, Try this =ROUNDUP((B1-A1)*24,0)/24 A1=Earlier time Mike "Ruth" wrote: Hi there I have a cell that has a formala that calculates the time spent at a port by subtracting the arrival time from the departure time. I want the same cell to always round the time up to the next hour, ei - if there for 2 hours and 10 minutes-- I want it to say 3 hours. As that is how we are charge. Is there a way to do this? If so, how? -- Thank-you! Ruth |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up time
You guys are so great! Thanks for sharing your brilliance!
"Mike H" wrote: Hi, Try this =ROUNDUP((B1-A1)*24,0)/24 A1=Earlier time Mike "Ruth" wrote: Hi there I have a cell that has a formala that calculates the time spent at a port by subtracting the arrival time from the departure time. I want the same cell to always round the time up to the next hour, ei - if there for 2 hours and 10 minutes-- I want it to say 3 hours. As that is how we are charge. Is there a way to do this? If so, how? -- Thank-you! Ruth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round time | Excel Worksheet Functions | |||
| Round down for time | Excel Discussion (Misc queries) | |||
| Round Up Time IF | Excel Worksheet Functions | |||
| Round UP Time | Excel Worksheet Functions | |||
| How do I round time? | Excel Worksheet Functions | |||
Linear Mode
