round off a cell

Mike · Feb 12, 2004

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 · Feb 12, 2004

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

Frank