round off a cell

[Mike]

I have cells that contain times. Is there a way to format the cell to round
the time to the nearest 15 minutes?

Mike

 

[Frank Kabel]

Hi Mike
try
=ROUND(A1*4*24,0)/(4*24)

Frank