# how can I calculate duration of a summary task?

Home Forums Discussion how can I calculate duration of a summary task?

Viewing 7 posts - 1 through 7 (of 7 total)
• Author
Posts
Gianluca Coppola
Guest

goodmorning everybody,

I’ve this problem:
I’d like to add a column in which I want to show the duration of tasks and summary tasks in calendar (solar) days. I’ve added a column, formatted as number, in which I’ve put this formula: “DateValue([Fine])-DateValue([Inizio])” (“fine” stands for end, “inizio” for start), but I get numbers with two decimal (17.38 days…?) for tasks, and I get 0 for summary tasks.
could anyone help me?

Participant

Gianluca Coppola – By solar days, I suppose you meant calendar days between start and finish. Insert a Number1 column and you can use DateDiff(). DateDiff(“d”,[Start],[Finish]) returns the number of calendar days between Start and Finish but this function will return a value one less that what is expected. For example, for Start = 1 Jan, Finish = 1 Jan, this function will return 0 but we expect 1. So, in the formula add 1 to the returned value. Let me know if this helps.

Gianluca Coppola
Guest

Hi, thank you very much for your help. the formula work properly with tasks, but I still get a “0” for the summary tasks. What’s wrong?
thanks again

Participant

Gianluca Coppola – Thank you. Have you selected “Use formula” for “Calculation for task and summary rows” — see the picture in my previous reply?

Gianluca Coppola
Guest

I feel really stupid!!!:-)

thank you so much, ciao

Participant

You are welcome

Malathi
Guest

Hi Sai,

I am also facing this same problem.. Can you please elaborate in detail about the above mentioned solution.. It will be very helpful for me . Thanks in advance.

Regards,
Malathi R
CBAP training

Viewing 7 posts - 1 through 7 (of 7 total)