A time formula question

  • Thread starter Thread starter Kyle
  • Start date Start date
K

Kyle

Hi, i want to calculate the difference between Cross
Country Times. Ex: Race1: 25:13 (thats 25min. 13sec.)
Race2: 26:45 (thats 26min. 45sec.) I know thats negative
but i would like there just to be a negative sign(-) by
the number. I am figureing out time differences from
race to race and i want to have the most improved from
one race to anthoer. and from year to year. I hope u can
help
 
If you choose Tools/Options/Calculate, you can check the 1904 Date
system checkbox which allows negative times to be displayed. Note
that any dates already entered in the workbook will be changed by 4
years and 1 day (as that is the difference in base dates).

If you only care about displaying the difference in the 1900 date
system, you can use:

=IF(B1<A1,"-","") & TEXT(ABS(B1-A1),"mm:ss")
 
Heres something you can use

+IF(F18<G18,1440*(MAX(F18:G18)-MIN(F18:G18)),"-"&1440*(MAX(F18:G18)-MIN(F18:
G18)))


You will have to display this cell as a number, and it will return the
minute and the decimal part of the minute that the difference is.

For example


Race1 Race2

28:13 25:13 Result : -3.00
23:13 24:13 Result: 1.00

meaning you ran the first row 3 minutes faster and the 2nd row 1 minute
slower.

----- Original Message -----
From: "Kyle" <[email protected]>
Newsgroups: microsoft.public.excel.worksheet.functions
Sent: Monday, October 06, 2003 2:46 PM
Subject: A time formula question
 
Back
Top