negative timevalue in D2

[lucarello]

Hallo, I know how to work before the event starts (I mean when D2 has a positive value, for instance 30 seconds before the start of the event).. it is easy, I use timevalue and compare with D2..BUT when D2 becomes negative (for instance when the event goes in play) the timevalue function can't work anymore with that cell..

So, if I need to check an odd after 4:37 seconds of play (it's an example, not the holy grail), is there a way I could do this?

thnx in adv and sorry for my english..

[Roger]

See this thread, in which I posted a formula to get round this problem.
http://www.gruss-software.co.uk/forum/v ... t=negative

[lucarello]

thank you veeery much Roger for this!