Forum Discussion
Unit and Work question
Sorry, but it doesn't quite make sense. You say you have a labor rate of .95 hrs per foot of conduit. That doesn't compute. Labor rate is cost per time (e.g. $/hr), so are you saying the cost is 95 cents per hour or 95 cents per foot? Or maybe you're not talking about labor rate but really mean performance rate (i.e. it takes 57 minutes to lay 1 foot of conduit).
If you are referring to performance rate, then yes, you can create a custom field for the total length of conduit to be laid, which is a value you enter, and a second custom field that calculates the total time based on the performance rate. You can then enter that calculated value into the Duration field.
For example, in this case I set up the Number1 field as the entry field for the total length of conduit run. I set up the Duration1 field with the formula to calculate the duration (Note, Project calculated all time values in minutes). The next step is to manually enter the calculated value in the Duration1 field into the Duration field. And yes, manual entry is the best way to enter the calculated value into the Duration field although with a simple VBA macro there would be no need for the custom field formula in the Duration1 field and no value would need to be copied, it would all be handled in code.
John