Hello,

I have two columns of data (From and To) and I want to calculate the
distance between the two stations and put in the third column. How do I
do it? Thank you very much.

From To Distance
0+00 5+10 510
5+30 6+75 145
7+11 12+13 502
12+35 14+80 245

- wcc

assume 0+00 is in A2

in C2
=ABS(SUBSTITUTE(B2,"+","")-SUBSTITUTE(A2,"+",""))

then drag fill down the column.

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
Hello,

I have two columns of data (From and To) and I want to calculate the
distance between the two stations and put in the third column. How do I
do it? Thank you very much.

From To Distance
0+00 5+10 510
5+30 6+75 145
7+11 12+13 502
12+35 14+80 245

- wcc