newbie question
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 |
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 |
All times are GMT +1. The time now is 05:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com