How to calculate the difference between 2 times of day & show 1/2 hr as .5 & not .3

[gloriousglenn]

My Title/Question even confuses myself, so let me try and explain! I have searched for this and found some answers but nothing that fits my query exactly.

I have cell D4 and E4 that show a start time and finish time of a shift (eg D4 is 21:30 and E4 is 23:59). I have figured out how to calculate how many hours it is, and how to round the figure to the next 1/2 hour:

=ROUND(SUM(E4-D4)*48,0)/48

The problem with this is that it shows the result as 2.30, which is obviously 2hrs and 30mins, but I need to show the result as 2.50 (2 1/2 hrs) because that cell will then be linked to an hourly rate of pay.

So, how can I change it so that the result shows as 2.5?

Any help would be greatly appreciated.
Cheers
Glenn

[tigeravatar]

Formula:
=CEILING(E4-D4,1.25/60)*24

Format as General

[gloriousglenn]

Perfect! Thank you so much. I have never used the 'CEILING' formula before, so I would have never have figured it out! Thanks again.