View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Converting decimal fractions of minutes to seconds

If 5.5 is in cell A1 then:

=.000656565*A1 and format as mm:ss
--
Gary's Student


"ronnie-g" wrote:

How do I convert 5.5 minutes to display 5:12 (5 minues 12 seconds).
Thanks!
--Ron