Time Round Up or Stay

[Dr. Evil]

I do not know how to get this Case to work. Anyone know how to make this work? I'm trying to round time up to nearest quarter hour, but only if the time is not divisible by 15min. My laymen calc that obviously does not work.

Case (

time_field = divisible by 15; time_field;

(Truncate(time_entry / 900; 0) * 900) + 900

)

I don't know how to check if field is divisible.

Any help will be appreciated, THANK YOU!

[comment]

Try:

Ceiling ( Timefield / 900 ) * 900

[Dr. Evil]

BRAVO! Very cool!

Thanks

: