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

    MakeTime from web data Date

      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