Thread: round up time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ruth Ruth is offline
external usenet poster
 
Posts: 132
Default 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