Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative time displaying as #####
Hi,
I currently have two times (formatted as general). Eg. 0525 (cell A2) and 0105 (cell B2). I have calculated the difference between the two times using the following formula: =TIME(LEFT(B2,2),RIGHT(B2,2),0) -TIME(LEFT(A2,2),RIGHT(A2,2),0) + (B2<A2) The problem comes when I try to override either cell B2 or cell A2. The output cell then gives me #### when the number is negative, or the wrong result when it is positive. Even if I change the formatting of A2 and B2 to custom (h:mm AM/PM), I get the same result (####) though I have also changed the formula to a simple subtraction of B2-A2. Does anyone have any suggestions - do I change the time format used, or the subtraction formula? Thanks in advance -- Carla |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying negative time | Excel Discussion (Misc queries) | |||
Displaying negative [h]:mm:ss | Excel Discussion (Misc queries) | |||
Displaying negative hh:mm:ss | Excel Discussion (Misc queries) | |||
Displaying negative time in excel | Excel Worksheet Functions | |||
More problems displaying a negative time | Excel Discussion (Misc queries) |