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

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

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.