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.