View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
youngxxi youngxxi is offline
external usenet poster
 
Posts: 1
Default Converting minutes to seconds


When I am entering the time in as 1:20 and format the cell to m:ss it is
changing the value to 20:00, any ideas why???


--
youngxxi
------------------------------------------------------------------------
youngxxi's Profile: http://www.excelforum.com/member.php...o&userid=37158
View this thread: http://www.excelforum.com/showthread...hreadid=568764