+ Reply to Thread
Results 1 to 4 of 4

excel formula to calculate days result achieved or not achieved

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    excel formula to calculate days result achieved or not achieved

    dear experts


    i want calculate total time and day between start/end time and result (achieved /not achieved). from total day
    condition if total day less than 1 one day is achieved if zone is a and sl is nd
    condition 2 if total day is less than 2 two day is achieved if zone is b,c,d or sl is 2bd,3bd,4bd
    if start time is saturday and end time also saturday means achieved other sunday not calculate


    please find the attachment
    Attached Files Attached Files
    Last edited by breadwinner; 07-21-2013 at 12:54 AM. Reason: upper case

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: excel formula to calculate days result achieved or not achieved

    You need to use lower case first of all
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: excel formula to calculate days result achieved or not achieved

    hi tried this formula but for second condition it would nt work
    =IF(AND(E2="A",F2="ND",NETWORKDAYS(G2,H2,"123456")<=1),"HIT",IF(NETWORKDAYS(G2,H2,"123456")<=2,"HIT","MISS"))

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: excel formula to calculate days result achieved or not achieved

    any expert help on this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting days until first value is achieved
    By Montoro22 in forum Excel General
    Replies: 1
    Last Post: 07-06-2012, 09:20 AM
  2. Closest time achieved
    By Qualo_Jinn in forum Excel General
    Replies: 9
    Last Post: 10-27-2011, 08:38 AM
  3. Running a Macro Until result Achieved
    By Thunderace in forum Excel General
    Replies: 9
    Last Post: 09-06-2011, 11:21 AM
  4. [SOLVED] Specifying the person who has achieved the highest result
    By Mary Ann in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2005, 03:10 AM
  5. Clickable pie chart - anyone know how this might be achieved?
    By Mark Stephens in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-07-2005, 11:06 AM

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