Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
Count the number of times a cell value is within a specific range | Excel Worksheet Functions | |||
Difference between date and times | Excel Discussion (Misc queries) | |||
Negative times | Excel Discussion (Misc queries) | |||
Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) |