rounding time formula

[jaydub]

This formula is for rounding the time up to nearest 15 min. increment, and rounding anything less than one hour up to one hour. The problem comes when the time is between 24 and 24:59...It returns 1. I only want 1 to appear if time is less than 1 hour. For example if time = 24 hr 0 min...1 is returned instead of 24.

=IF((U4-INT(U4))*24<1,1/24,ROUNDUP(U4 * 96, 0) / 96)

Basically does what I want unless the time is 24:00 to 24:59...Everything else seems to work.

jw

[martindwilson]

doesn't just
=CEILING(U4,1/96)
work
then again 24:00=00:00 so 24:01 is less than 01:00