How do you display negative time?
Posted by Roy Slaven on December 12, 2001 2:26 AM
I am using m:ss.00 format to record my lap times in a racing game I play.
There is a benchmark figure to compare my times to, and if I do a better time than the benchmark, it should result in a negative time difference.
I cannot get Excel to display this negative time.
I tried going...if(a>b then "-"& a-b)... or words to that effect, but it didn't work either.
Can anyone offer any suggestions please?