Round time up to nearest :15

[Amy]

I am currently using this formula to round to the nearest :15 --
MROUND(D2,0.25/24)
However I Need it to round UP to the nearest :15.

Any suggestions?

 

[Mike H]

Try

=CEILING(D2,1/ (24*4))

Mike

 

[Amy]

Thank you, perfect

Try

=CEILING(D2,1/ (24*4))

Mike