How do I format 2 cells (A1 & B1) so that when the entered data is in "Station" format, I can sum up the 2 cells in a "Number" format in C1? For instance:

A B C 1 40+49.52 40+97.52 48.0

Thanks,Mike

What is "Station" format? How does C1 (48.0) relate to what's in A1 and B1?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

In Civil Engineering, Station or STA is assigned by the design engineer on a street, a flood control channel or a storm drain (SD), etc. For instance, for a local street which intersects at a collector street at STA 10+00 and continues to STA 100+00, therefore the distance between the stations is 10,000 - 1,000 = 9,000 LF or the street is 9,000 feet or 1.7 mile long. Even though A1 displays as 40+49.52, its value is 4,049.52

and 40+97.52 has a value of 4,097.52. Hence, the distance between the locations in A1 & B1 is 4,097.52 - 4,049.52 = 48 LFI hope that helps!

=SUBSTITUTE(B1,"+","")-SUBSTITUTE(A1,"+","")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Worked great! You saved the day again!

Thanks,

Mike

Ask Your Question

Weekly Poll