round up time

[Ruth]

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?

 

[Bob Phillips]

=ROUNDUP(F1*24,0)/24

 

[Bob Phillips]

Don't even need the --

=CEILING(F1,"1:00")

 

[Mike H]

Hi,

Try this

=ROUNDUP((B1-A1)*24,0)/24

A1=Earlier time

Mike

 

[Ruth]

Thank-you - all 3 methods worked.

 

[lolan7]

You guys are so great! Thanks for sharing your brilliance!