Author Topic: writing CSV and time format  (Read 1257 times)

Tags:
  • All members
  • Posts: 11
  • Gender: Male
writing CSV and time format
« on: 23 Mar 2020, 17:46 »
Hi all I need some help please 
Im using a trigger to download markets and its bringing the data to a csv file ,I wish to use this CSV file along with another Excel file I have to match some data and then drive a file to use within MF Pro as a pick list.
The problem I have is that the downloaded file from the trigger brings in time as text I guess and I can't convert that text to the time it shows so 10:46 to be 10:46 in the morning ,it appears to want to change it to decimal part of a day no matter what calculation or formatting I perform 

Im not bad at all with learning stuff and Ive searched the net all day for a solution to this and tried lots of methods but it continually stays as 10.46 or recognises it as the digital version of 10.46 

Thank you 

  • All members
  • Posts: 11
  • Gender: Male
Re: writing CSV and time format
« Reply #1 on: 24 Mar 2020, 15:48 »
Ive solved this elsewhere ..thank you 

 

Please note, BetFair is seems to be currently OFFLINE