+ Reply to Thread
Results 1 to 2 of 2

Duration of a Task

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Duration of a Task

    Please any help

    A1 = Task Starating date B2 = Task ending date C1= Task Duration


    A2 = Sub Task 1 Starting Date B2 = Sub Task 1 Starting Date C2= Sub Task 1 Duration 5 Days
    A3= Sub Task 2 Starting Date B3= Sub Task 2 Starting Date C3= Sub Task 2 Duration 6 Days
    A4= Sub Task2 Starting Date B4 = Sub Task 3 Starting Date C4= Sub Task 3 Duration 7 Days

    Formulas on A1 =MIN (A2:A4) Give a Date ( This Correct )
    Formulas on B2 = A1+C1 -1 Give a Date ( This Correct )

    Formulas on C1 =MAX(C2:C4)-A1+1
    Here I have a Problem I want to average in day the length / duration of the task on C1 , but instead I am getting some strange number

    Any Hint

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Duration of a Task

    Did you mean this:

    Please Login or Register  to view this content.
    If you have calculated A1 and B1, C1 is simply

    =B1-A1

    Not sure what you are trying to do with

    =MAX(C2:C4)-A1+1

    It takes the longest subtask duration and subtracts the main task starting date, which makes no sense.
    Last edited by 6StringJazzer; 01-14-2013 at 08:17 PM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1