Ok, me again! So next question is regarding the export feature on the Zwift leagues, when I asked to get standings I get a csv file. When looking at it there is some headings I understanding, but there are some that I’m finding tricky to interpret. Basically though, if my league is based on time (please see attached example)
As always thanks for the help and understanding
Kind Regards
Kev
Not something i’ve every looked at but just trying export on my league to take a look i’m guessing it’s still the points columns but needs converted into readable times.
What are the two time values in your league on zp?
Hi Gordon,
The times are 29:16 and 32:23
Kind Regards
Kev
points are the times in milliseconds.
While you are in excel
=CONCATENATE(TEXT(INT(A1/1000)/86400,“hh:mm:ss”),“.”,A1-(INT(A1/1000)*1000))
Where A1 is millisecond value
Thanks Gordon, I’ll give that a bash!
