newbie question

[wccppp]

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

 

[Tom Ogilvy]

assume 0+00 is in A2

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

then drag fill down the column.

 

[wccppp]

Thanks a lot Tom.

- wcc