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