Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NEGATIVE HOURS (3)
Excell 2000
I read your comments ad I would like to precise my needs. I tried to format the cell like you told me to do < -h:mm and when I type 8:00 the result gives -8:00 but no further calculation can be made such as : Let say -8:00 in A1 and 2:00 in cell A2 and formula A1-A2 in A3 should give me -10:00 as a result in A3. Any others ideas ?? Thanks! André Lavoie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
NEGATIVE HOURS (3)
You received two suggestions on how you could workaround this limitation.
Charle's suggestion, which seems to be the only one you accepted, it off the mark/incorrect and does as you say, not produce a negative time value. -- Regards, Tom Ogilvy "André Lavoie" wrote in message .. . Excell 2000 I read your comments ad I would like to precise my needs. I tried to format the cell like you told me to do < -h:mm and when I type 8:00 the result gives -8:00 but no further calculation can be made such as : Let say -8:00 in A1 and 2:00 in cell A2 and formula A1-A2 in A3 should give me -10:00 as a result in A3. Any others ideas ?? Thanks! André Lavoie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
NEGATIVE HOURS (3)
One possible workaround would be to deliberately negate the "negative"
value in subsequent formulae. For instance, if A1 should always be negative, format as -h:mm and enter a positive number. Entering 8 will display -8. Format A2 as h:mm and enter 2:00. In A3 enter =-A1-A2 formatting as h:mm. The result will be -10:00 (1904 date system). I don't recommend this, of course - it's a maintenance nightmare. And obviously this would prevent a positive value being evaluated correctly. In article , "Tom Ogilvy" wrote: You received two suggestions on how you could workaround this limitation. Charle's suggestion, which seems to be the only one you accepted, it off the mark/incorrect and does as you say, not produce a negative time value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
Negative hours [h]:mm:ss | Excel Discussion (Misc queries) | |||
I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
How can I show hours of more than 24 & negative hours? | Excel Worksheet Functions | |||
NEGATIVE HOURS (2) | Excel Programming |