Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |