Loading...
Quick Links

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
  • #300831 Reply
    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?

    thanks in advance

    #300854 Reply
    Sai PrasadSai Prasad
    Participant
    • Community Leader
    • Forum Pro

    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.

    #300878 Reply
    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

    #300879 Reply
    Sai PrasadSai Prasad
    Participant
    • Community Leader
    • Forum Pro

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

    #300880 Reply
    Gianluca Coppola
    Guest

    I feel really stupid!!!:-)

    thank you so much, ciao

    #300882 Reply
    Sai PrasadSai Prasad
    Participant
    • Community Leader
    • Forum Pro

    You are welcome

    #308144 Reply
    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)
Reply To: how can I calculate duration of a summary task?
Your information: