Solved Format Cell in MS Excel

July 13, 2011 at 22:24:59
Specs: Windows 7, Intel Core2Duo/8GB
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


See More: Format Cell in MS Excel

Report •

#1
July 14, 2011 at 13:00:21
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.


Report •

#2
July 14, 2011 at 19:59:26
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 LF

I hope that helps!


Report •

#3
July 14, 2011 at 21:03:09
✔ Best Answer

Report •

Related Solutions

#4
July 15, 2011 at 06:16:06
Worked great! You saved the day again!
Thanks,
Mike

Report •

Ask Question