D2 Cell

[bonafu]

How can I change the inplay-time in cell D2, which has a "-" prefix, into a time without the prefix?

For example:

-00:16:00 to 00:16:00 and then to 16

Thanks for help

[mak]

this is from Gary
it will convert d2 time to seconds

=IF(LEFT(D2)<>"-";(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2);-((HOUR(SUBSTITUTE(D2;"-";""))*3600)+(MINUTE(SUBSTITUTE(D2;"-";""))*60)+SECOND(SUBSTITUTE(D2;"-";""))))


Gary
as a suggestion can you add in BA a cell that perform as this formula, i think
80% of the users are asking the particular question

[easternpromise]

Is there a way to adapt this formula, so i can count the race time once its gone in play?

I am trying to time my bets once the race has started

[Captain Sensible]

I have this code in one of my sheets that shows the amount of seconds the race has been inplay in cell X2 and the off time in cell x1



If Cells(2, 5) = "In Play" Then
If Cells(1, 24) = "" Then Cells(1, 24) = Cells(2, 3)
If Cells(1, 24) <> "" Then Cells(2, 24) = DateDiff("s", Cells(1, 24), Cells(2, 3))
End If
If Cells(2, 5) <> "In Play" And Cells(2, 6) <> "Suspended" Then
Cells(1, 24) = ""
Cells(2, 24) = ""
End If

[Captain Sensible]

The second part just resets the counter for me for the next market obviously there's no need for you to use that just use something else to reset the cell x1 and x2 to ""

If Cells(2, 5) = "In Play" Then
If Cells(1, 24) = "" Then Cells(1, 24) = Cells(2, 3)
If Cells(1, 24) <> "" Then Cells(2, 24) = DateDiff("s", Cells(1, 24), Cells(2, 3))
End If