newbie question
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
|