Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula in Custom Work field not working

Status
Not open for further replies.

jdavis501rp

IS-IT--Management
Nov 30, 2000
1
US
Can anyone help with a potential solution to this problem?
I need a custom field for Remaining Work which will allow me to show the total remaining work for only those resources in a particular group. I have some resources for which I include work hours but don't want their remaining hours to show in the "Remaining" column I'm going to use.

I thought I could set up a custom flag to indicate by yes/no if the resource for the task is one that I track remaining hours for, and then say something like
IIF(([TrackResc]="YES", ([Work]-[Actual Work]), 0)) in the formula for my custom 'remaining' field, but I get a number generated that is the Work column multiplied by 60. Work is in hours, and I'm speculating that MSProject is doing something under the hood that I don't know about. Any ideas?
 
Under the hood, Project tracks everything by the minute (start, finish, work, duration, etc., etc., etc.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top