NEGATIVE HOURS (3)

[André Lavoie]

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

 

[Tom Ogilvy]

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.

 

[JE McGimpsey]

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.