Negative Times Displayed as # # # #
 

Cells A1:C1 are formatted as "h:mm:ss."
A1 is the time it took to complete a task the first attempt. B1 is the
time of the second attempt (preferably with a faster time). I want to
have C1 show the difference of the two attempts (B1-A1). This
calculates the difference perfectly if A1 is less than B1 (if it took
longer the 2nd time). However, Excel returns "######" if A1 is greater
than B1.

What is the best way to display a negative time difference (negative
being better in this case)?

Negative Times Displayed as # # # #
 

One way is to toggle the 1904 date system setting:

Tools|Options|Calculation tab|Check 1904 date system.

Be aware that if you have dates in that workbook, those dates will change.

And copying between two workbooks that have different date systems is a problem,
too.

AntnyMI wrote:

Cells A1:C1 are formatted as "h:mm:ss."
A1 is the time it took to complete a task the first attempt. B1 is the
time of the second attempt (preferably with a faster time). I want to
have C1 show the difference of the two attempts (B1-A1). This
calculates the difference perfectly if A1 is less than B1 (if it took
longer the 2nd time). However, Excel returns "######" if A1 is greater
than B1.

What is the best way to display a negative time difference (negative
being better in this case)?

--

Dave Peterson