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.

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.

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.

Hi

You could cheat!!
If times are in A1 and B1,
in C1
=IF(A1B1,1,-1) and hide the column
In D1
=MAX(A1:B1)-MIN(A1:B1)
Use FormatConditional FormatFormula Is =A1<B1
Format cells as Red

To get the total time, then use
=SUMPRODUCT(C1:C100,D1:D100)

--
Regards

Roger Govier



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.