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

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History