Time Formula

D

DMJohnson

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.
 
G

Gary''s Student

Pull=down:

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

Chip Pearson

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



in message
 
R

Roger Govier

Hi

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

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