Timestamp race start tim

[vanbuuts]

Any way I can timestamp the starting time of the race in cell AC3 ??

[Captain Sensible]

Just use a bit of VBA, something like below should probably work OK

Code: Select all

 If Worksheets("Sheet1").Range("E2").Value = "In Play" And Worksheets("Sheet1").Range("AC3").Value = "" Then
 Worksheets("Sheet1").Range("AC3").Value = Worksheets("Sheet1").Range("C2").Value
 ElseIf Worksheets("Sheet1").Range("E2").Value <> "In Play"
 Worksheets("Sheet1").Range("AC3").Value = ""
 End If

[vanbuuts]

Thanks CS will give it a blast for tomorrows racing

[Captain Sensible]

No problem , probably best to test it out on the dogs or something just to see i it timestamps as you want before using it for real.

Just noticed I'd missed out a then on the code above, probably best amended to the code below as it should only fire when neccessary

Code: Select all

 If Worksheets("Sheet1").Range("E2").Value = "In Play" And Worksheets("Sheet1").Range("AC3").Value = "" Then
 Worksheets("Sheet1").Range("AC3").Value = Worksheets("Sheet1").Range("C2").Value
 ElseIf Worksheets("Sheet1").Range("E2").Value <> "In Play" And Worksheets("Sheet1").Range("AC3").Value <> "" Then
 Worksheets("Sheet1").Range("AC3").Value = ""
 End If

[vanbuuts]

Works perfectly, many thanks