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