2 Replies Latest reply: Mar 1, 2013 8:25 AM by Sally Bow RSS

    MakeTime from web data Date

    Sally Bow

      Hi All,

       

      I have loaded some data from a web page.

       

      This data contains a time (mm:ss.hs), but some of it shows as txt and some as a date.

       

      I have tried MakeTime, by 1st seperating the Mins/Secs/ and Hundreths into new fields.

       

      Time(Field,'mm:ss.ff') this does not work either.

       

      Please can someone come up with a solution for me as I need to use this data in a line chart, and in its current format it does not work.

       

       

       

       

      Thank you