B

#### brzak

simple answer...

why is the value of the resulf of:

00:09:00 - 00:01:00 (that is 9mins - 1 min, i.e. 8 minutes)

not equal to:

9/24/60 - 1/24/60 (as above, since 1 = 24 hours, so 1 minute =

1/24/60)

whereas the value of 00:5:00 - 00:01:00 *is equal to* the result of

5/24/60 - 1/24/60

The text below is a sample to demonstrate the problem (select the

text, starting from google groups and to the end of my post, paste

into cell A1 in a new spreadsheet, it's semicolon delimited - do 'Text

to Columns' and select the semicolon delimiter option in the wizard

that comes up). Thanks in advance for any insight into this one.

google groups demo;9 minutes;1 minute;9 mins - 1 min;value

time function;=TIME(0,9,0);=TIME(0,1,0);=B2-C2;=VALUE(D2)

fraction;=9/24/60;=1/24/60;=B3-C3;=VALUE(D3)

comparison;=B2=B3;=C2=C3;=D2=D3;=E2=E3

;10 minutes;1 minute;10 mins - 1 min;value

time function;=TIME(0,5,0);=TIME(0,1,0);=B6-C6;=VALUE(D6)

fraction;=5/24/60;=1/24/60;=B7-C7;=VALUE(D7)

comparison;=B6=B7;=C6=C7;=D6=D7;=E6=E7