=CONCATENATE(1,":",ROUNDDOWN(A1/B1,0))
--
Gary's Student


" wrote:

I used the ffollowing to get the conversion ratio format I wanted
CONCATENATE(1,":",A1/B1)

Now I am trying to figure out if there is a way to show the results in
a whole number ie 1:32 instead of 1:32.6666666.

Is there a way to do that?