From the beginning

[barakg]

Hi,
Is there anything in the data that is transffered from BA into excel that tells you (Directly) the amount of time that has passed since the beginning of the race?

Thanks

[alrodopial]

No, it must be calculated by excel with vba

[mak]

this is a vba code from Gary
start counting after the market turns in play



If BA_Array(2, 5) <> "In Play" And BA_Array(2, 6) <> "Suspended" Then
.Cells(1, 27) = ""
.Cells(1, 28) = ""

ElseIf BA_Array(2, 5) = "In Play" Then
If BA_Array(1, 27) = "" Then
.Cells(1, 27) = BA_Array(2, 3)
BA_Array(1, 27) = BA_Array(2, 3)
End If
If BA_Array(1, 27) <> "" Then .Cells(1, 28) = DateDiff("s", BA_Array(1, 27), BA_Array(2, 3))
End If

[barakg]

Thanks