| 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)? |
| 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) | |||
Threaded Mode
