Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

cost travel time

Forum home » Delegate support and help forum » Microsoft Project Training and help » Cost of travel time

Cost of travel time

ResolvedVersion 2007

Terry has attended:
Project Intro Intermediate course

Cost of travel time

How do I formulate a view for the cost of travel in miles and show it in my plan as time? eg 1 mile = x time and time = x cost.

RE: Cost of travel time

Hi Terry

Thank you for your question. You can get Project to calculate values for you. From the Tools menu choose Customize > Fields and choose set the type to number. You can rename this as Mileage (eg miles to project). Do the same thing with another field of type Cost renamed as Rate.

Lastly make a cost field called Expense and click on the Formula button. In the formula box build a formula that will multiply mileage by cost. The formula would look like [Mileage]*[Rate]. The square brackets identify the field names.

Finally add in the columns to the table (Insert > Column) Put a value in Mileage, a rate value in the Rate column and Project will calculate the Expense.

I hope this is a useful start to using fields within Project to calcluate values. Do let us know if you have any further questions.

Kind regards,
Andrew

Fri 7 Aug 2009: Automatically marked as resolved.

MS Project tip:

Set default task type - Project 2010

a. In Project, click on the File tab
b. Select Options from left hand side
c. Click on Schedule to set the scheduling options
d. Set the Default Task type box to your chosen option
i. Generally if you plan/estimate your projects using durations you should use fixed duration, and untick the box New tasks are effort driven, if you plan/estimate with person hours use fixed work, or for plans estimated with the proportion of resources time use fixed units, and untick the box New tasks are effort driven)
e. Click OK to apply your changes

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.