drewsy said:
is there a way to make a formula so that if the sum is greater than 40 hours,
the overtime goes into another cell
drewsy,
Maybe yes and maybe no, it depends on many factors. One of the main
limitations with formulas is that they only work on the task or resource
row where the formula is located. I suppose if your plan is such that
all tasks have a duration of 1 week, or at least that the total
assignment hours for each task is 40 hours or less, then a formula might
work. However, formulas do not generally change basic Project fields
(e.g. Start, Finish, Duration, Cost, Work, etc.), so even if the Work
for a particular task (or resource) was greater than 40 hours, you could
"capture" the excess over 40 and put it into a spare field but the Work
field itself will still show the total (i.e. more than 40).
For what you are trying to do, VBA would be much more appropriate and
work much better.
John
Project MVP
