Division of 2 custom field numbers in MS Project to get result in custom field duration?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 30%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
shuvro chatterjee
1
Reputation point
How to divide two numbers (custom field number 1) and (custom field number 2) and get the result in (Custom field duration 1). that is to say if (custom field number 1) = 1000 (custom field number 2)=10 then (Custom field duration 1) should give result 100. I have tried formula ProjDurConv([Number1]/[Number2],pjDays) in (Custom field duration 1) but I get result 0.14 days. Why such error? Note: My task type is Fixed units & Calendar is 24 hrs. Thanks