calculate rest of cells

[aocana]

some one can tell me how can calculate diff of these cells?

a1= 0.000000s
b1= 0.225614s
c1= time diff between a1-b1 (time in mcd)



thanks!

[AlKey]

And what result do you expect from A1-B1?

[Fotis1991]

Do you mean?

Please Login or Register  to view this content.

[aocana]

cell c3 = VALUE!

it doesn'n works

[AlKey]

Try this:

=ABS(LEFT(A1,LEN(A1)-1)-LEFT(B1,LEN(B1)-1))

[Fotis1991]

to me gives 225,614 as result.

[aocana]

nothing.. show cell c3= value!

any special format for this cells..?

[Fotis1991]

....................

[aocana]

two consideration that could be important
cell A = 0.000000s
cell B = 0.225614s

i have market in red color "." and also "s"

[AlKey]

Did you try my formula?

	A	B	C
1	0.000000s	0.225614s	0.225614
2
3

[aocana]

AlKey,

thanks for your formula, but only works if I change "." to "," on value of cells, example:
when cell A is: 0.000000s , I must to change to 0,000000s
Is there any way to conserve point like separator of decimals?

[AlKey]

Maybe this:

=ABS((LEFT("0."&MID(A1,3,FIND(".",A1)+LEN(A1)-2),LEN(A1)-1)-(LEFT("0."&MID(B1,3,FIND(".",B1)+LEN(B1)-2),LEN(B1)-1))))