View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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