Thread: Need to convert Minutes:Seconds format to minutes with seconds con
View Single Post
  #4  
Old June 18th, 2009, 05:22 AM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
  
Posts: 8,714
Default Need to convert Minutes:Seconds format to minutes with seconds con
=A1*1440 and format as number or general.
--
David Biddulph

Cliff wrote:
Need to convert Minutes:Seconds format to minutes with seconds
converted to a decimal