software

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 gt; Options... gt; Calculation and check the 1904 data system
--
Gary's Studentquot;DMJohnsonquot; wrote:

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

gt; Tools gt; Options... gt; 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
quot;Gary''s Studentquot; gt; wrote
in message
...
gt; Pull=down:
gt;
gt; Tools gt; Options... gt; Calculation and check the 1904 data system
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;DMJohnsonquot; wrote:
gt;
gt;gt; I need a formula to calculate differance in set times.
gt;gt; Example: 2:39 and 2:49 (m:sec) The problem is negative times
gt;gt; display as
gt;gt; ######.
gt;gt; Some solutions will be positive and some negative.
Hi

You could cheat!!
If times are in A1 and B1,
in C1
=IF(A1gt;B1,1,-1) and hide the column
In D1
=MAX(A1:B1)-MIN(A1:B1)
Use Formatgt;Conditional Formatgt;Formula Is =A1lt;B1
Format cells as Red

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

--
Regards

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