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.