Cost of travel time

Resolved · Medium Priority · Version 2007

Thu 30 Jul 2009, 16:19 Delegate Terry said...

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.

Fri 31 Jul 2009, 16:59 Trainer Andrew said...

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.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

MS Project tip:

Create own ribbon tab - Project 2010

a. In Project click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all MS Project hints and tips