View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pauls56 pauls56 is offline
external usenet poster
 
Posts: 4
Default converting seconds into minutes

Hi, I am working on a spead sheet that in D colum has 76.50 this represents
76 seconds and .50 100's of a second
I am tring to come up wit a formula that will convert this to 1:06.50 in the
next colum E.
Colum D has appox. 68 cells all with various times in them like 143.89 again
this ia seconds and iooth of a second which should convert to 2:23.89
2min:23sec.and .89 one hunderths of a sec. Im stumped :)

Thanks PaulS56