Search:

Type: Posts; User: Red Corvette; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    Sorry beginning of formula is =NETWORKDAYS not +
  2. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    I used a deferent formula that seems to be working i.e. +NETWORKDAYS(stat,end,Holdays)+start-end-INT(end-start)-1 The only issue with this is the elapsed time columns full of #### what would need to...
  3. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    I re-formatted the columns and this does seem to work other than it is adding 24 hours to the results?
  4. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    Being this formula is not working for some reason what would the formula be to only include work days.
  5. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    I copied the start date and past special formats and it now shows True but I still have the same formula result #VALUE !
  6. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    I managed to figure out how to use ISNUMBER via YouTube and the end date comes up False how do I fix it?
  7. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    Don't know anything about using F9 here is how I entered the formula =(P2-N2)-(DAYS(P2,N2)-NETWORKDAYS(N2,P2,Info!C36:C43))
  8. Replies
    15
    Views
    300

    Re: Elapsed Time (h):mm:ss

    Thank You for the quick response but for what ever reason the formula did not work the result comes up #VALUE !
  9. Replies
    15
    Views
    300

    Elapsed Time (h):mm:ss

    Hello, new to the forum with little knowledge of Excel. I've been searching for a formula for elapsed time showing in (h):mm:ss between to date/time Stamps i.e. Start date/time 7/10/2019 10:53 AM and...
Results 1 to 9 of 9