View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LondonLion
 
Posts: n/a
Default converting seconds into minutes

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