Negative Times Displayed as # # # # "AntnyMI" <ASPhelps[ at ]comcast.net> 21.09.2006 15:31:39 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)?

Re: Negative Times Displayed as # # # # Dave Peterson <petersod[ at ]verizonXSPAM.net> 21.09.2006 15:43:15 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: [Quoted Text] > > 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