... need formula...

J

jkazan

Hi

I need formula which calculate finish day.


I have start day and number of hours for task - how to calculat
automatically finish day??


Regard
 
J

Jim Aksel

As Andrew asked, why?
That said, do not confuse duration with work. The duration (days) of a task
depends on the amount of work (hours) and resources assigned. An 8 hour task
may be accomplished in 2 hours duration with 4 people assigned.

Work=Duration x Assignment Units

Once you have settled on a correct duration for the given number of work
hours, the formula below will return a finish date:

ProjDateAdd( [Start], [Duration], calendar )

You can read more about this in the help.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Changing Baseline dates due to snow days 0
Change Working Days to Calendar Days without Impacting the Task Dates 1
New formula in field 17
Receiving unexpected Duration 0
additional columns, calculate finish day 5
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Projects and Tasks without a Start date and/or finish date:MS Project 2007 1

Top