Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2010, 01:18 PM
ericfons ericfons is offline custom formula for duration Windows XP custom formula for duration Office 2003
Novice
custom formula for duration
 
Join Date: Mar 2010
Posts: 1
ericfons is on a distinguished road
Default custom formula for duration

Consider the following scenario:



I am a flooring contractor and I track all my jobs as
one MS project. I am planning work for 2 homes where home 1 (H1) is 1000 sq feet, and home 2 (H2) is 2000 sq feet.

It takes one person-day to finish 500 sq feet. When I create a new task for H1, I simply want to enter 1000 sq ft in a field as an input about H1 and then I want MS project to calculate 1000/500 = 2 days as the duration for H1.

Similarly, I want to enter 2000 sq ft in a field an input about H2 and then I want MS project to calculate 2000/500=4 days as the duration for H2.

I know how to create a custom field. This would the area (square feet) of a home, say, homeArea. What I do not know is how make MS Project set the duration field automatically = homeArea/500

Please help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom formula for duration Help with Formula Corca Excel 6 02-22-2010 09:40 PM
custom formula for duration If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
custom formula for duration Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM
custom formula for duration Having problems with Duration calculations. bgane Project 1 03-20-2006 06:36 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft