MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you display negative time?


Posted by Roy Slaven on December 12, 2001 2:26 AM

Hello,
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?
Thanks



Posted by Mike C on December 12, 2001 3:59 AM

How about:

=if(A1>B1,"-"&TEXT(A1-B1,"h:mm:ss"),B1-A1)

Be sure to format the cell with this formula as "h:mm:ss" and set it to right justify.

Posted by Aladin Akyurek on December 12, 2001 4:32 AM

Or switch to the 1904 date system. [NT]