+ Reply to Thread
Results 1 to 3 of 3

Turn-Time calculation

  1. #1
    Registered User
    Join Date
    07-30-2010
    Location
    california
    MS-Off Ver
    Excel 2003
    Posts
    1

    Turn-Time calculation

    So I have a file that has a cell with a predicted turn time date for getting a task done. which is based on a date in another cell (original date) + 10 days. I have 2 or more other cells that have dates entered for other parts that need to be added in if they take longer...if any of these dates are farther along than the original date listed (the original date cell) then the number of days they are farther along should also be added into the predicted turn time date ie original date +10 days + 1 day (this day was one day further than the original) +2 (another that was further along) etc. I am trying to get the calc to do this. see below

    a1 = 1/1/10 (original date)
    a2 =1/2/10(one day over original date)
    a3= 1/3/10(2 days over original date)
    a4 = predicted turn time (original date +10 days +1 day over original +2 days over original) = 1/14/10


    Hope i am not confusing the issue. some some of the extra fields added may not always be used in the predicted turn time unless they are after the original date and they are applicable, in some cases we would not enter a date in them so it would not add to the predicted date.

    thank you for any help!!!!
    Last edited by cosmicflux; 07-30-2010 at 07:38 PM.

  2. #2
    Registered User
    Join Date
    07-30-2010
    Location
    CPH
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Turn-Time calculation help

    =a1+10+IF(a2>a1;a2-a1;0)+IF(a3>a1;a3-a1;0)

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Turn-Time calculation

    comsicflux - when you use the above change ; to , to reflect your US locale.

    You can use MAX rather than IF for this type of test - quicker (not that you'd notice)

    =A1+10+MAX(0,A2-A1)+MAX(0,A3-A1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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