Tools Options... Calculation and check the 1904 data system

Note that this will cause existing dates to be 4 years and a day
off.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Gary''s Student" wrote
in message
...
Pull=down:

Tools Options... Calculation and check the 1904 data system
--
Gary's Student


"DMJohnson" wrote:

I need a formula to calculate differance in set times.
Example: 2:39 and 2:49 (m:sec) The problem is negative times
display as
######.
Some solutions will be positive and some negative.