Thread: [Solved] Adding station numbers
View Single Post
 
Old 01-26-2015, 06:46 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by mbenton View Post
Sometimes in engineering and surveying, distances along a line or curve from a beginning point are expressed as station numbers. For example, the first point could be 50.50 feet from the beginning point and would be expressed as 0+50.50, the next point might be 136.68 feet from the beginning point and would be expressed as 1+36.68 and the next point might be 243.89 feet from the beginning point and would be expressed as 2+43.89. Can someone show me how I can get excel to add or subtract these station numbers?

Thanks in advance for your help.
I'm not sure I understand how this works. Does the number to the left of the plus sign always correspond to the hundreds portion of the distance?

If so, you can convert such numbers with the following:
=LEFT(A1,FIND("+",A1)-1)*100+RIGHT(A1,LEN(A1)-FIND("+",A1))
Reply With Quote