Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Stationing and Excel in the Auto Sum

### #1 gunn1 Posted 11 March 2010 - 10:10 AM

gunn1

Member

• Member
• 65 posts
I am quite a novice at Excel and all its possibilities.
With that being said, I have been able to produce a self calculating Time sheet/Pipe Progress report in a template form.
What I am having trouble with is figuring out how to make the Auto Sum function notice the form of measurement refered to as stationing.
Were the normal formual would Look like 0'+100' = 100' In the stationing format it would look like this 0+00-1+00= 100'. Also in Pipe or street work you may start at 0+00 and end at 1+25 (=125') The following day you would start at 1+25(where you left off the day before)and end at say station 2+50. Which would look like this 1+25-2+50=125'.

Is there a way to get Auto Sum to "notice" these numbers? If so which Auto Sum/Data link would I use?

Oh, and I am running Windows 7 with the newest edition of Microsft Office/Student

Any Information would be greatly appreciated, Thank you.

Gunn
• 0

### #2 wannabe1 Posted 11 March 2010 - 07:06 PM

wannabe1

Tech Staff

• Technician
• 16,645 posts
You have a duplicate topic in the correct forum HERE.

I'll close this one to avoid confusion.
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users