Now that's interesting. Very useful information. Thanks.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Ron Rosenfeld" wrote in message
...
On Wed, 23 Mar 2005 21:56:28 -0600, "Fred Smith"
wrote:

Excel doesn't handle negative times well, so make sure you subtract the
earlier from the later date.

To expand on your comment:

Excel, using the 1900 date system, does not DISPLAY negative times/dates.
However, the value in the cell remains correct (as in fractions of a day,
be
they positive or negative) and can be used in other formulas; or formatted
as
other than time or date.


--ron