=A1/24/60/60

Format Custom as mm:ss.0

--
Kind regards,

Niek Otten

"LondonLion" wrote in message
...
Hi, I have a number of seconds eg 186.4 in one cell and would like to
convert
this into minutes & seconds eg 03:06.4. Can this be done, I have tried
formatting and the TIME and CONVERT functions but seem unable to to this
??

Thanks