Formula Help

[redjay]

Hi Guys

I have a formula in G1 which is calculating a time difference between D1 and C1

=INT((D1-C1)*24)


This sort of works as I need G1 to be a number. However if there is a half hour time difference between D1 + C1, the formula rounds the number down. So if I had 12.30 and 11.00, G1 displays 1.00. For my purposes I need the formula to round UP to the nearest hour.


Can anyone help?

Many thanks

 

[jasonb75]

One way

=ROUNDUP((D1-C1)*24,0)

 

[redjay]

Superb!

I didnt know much about ROUNDUP. Many thanks