C field to show the expected amount of time to be spent on a task

T

Thillai

What is the formula for a custom field to show the expected amount of time to
be spent on a task on a particular day?

Can anyone help me for this?
 
D

Dale Howard [MVP]

Thillai --

You need to examine the assignment Work field in either the Task Usage view
or Resource Usage view. If you apply the Task Usage view and zoom the
timescale to Weeks Over Days, you will see the assignment Work field in the
right half of the view (the timephased grid). You can examine the Work
assigned to a resource on any day. Hope this helps.
 
R

Rob Schneider

Before the formula can be created, we would need to know the rules and
algorithm for doing this computation. How do you define "expected
amount of time to be spent on a task on a particular day"?

Is what you want different than built-in Project capability to show
"work" which you can see for a day in the Resource Usage View (Menu:
View/Resource Usage)? Scale the time table (at right) to show days.

--rms

www.rmschneider.com
 
J

Jan De Messemaeker

Hi,

There is, as my learned colleagues pointed out, a simple way to read that
value in a Usage view.
However, if you really want what you ask for in a custom field, that cannot
be done by a formula. You will need VBA coding.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
 
Top