2 Replies Latest reply: Apr 16, 2014 4:48 AM by Jonathan Dienst RSS

    converting decimals to seconds

    Håkan Fogelin

      I have an Excel spreadsheet with a column that says 2:49, 2 minutes and 49 seconds. When I try

      to pick the minutes and seconds I get a strange result. When formatting the cell in Excel I can see

      0,00833333333333333. How do I get this to minutes and seconds in my script? Is there any formula

      to convert?

       

       

      kindly

      Håkan