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

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?

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

How about:


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]