[gunn1]

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

[Advertisements]

You have a duplicate topic in the correct forum HERE.

I'll close this one to avoid confusion.

[wannabe1]

You have a duplicate topic in the correct forum HERE.

I'll close this one to avoid confusion.