This content has been marked as final. Show 2 replies
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.