• MVP Logo
  • Recent Forum Posts

    sonbarse

    Hours Between the Days

    Thanks For the Quick Response. The amendment in the Formula worked.
    Will Explore More on the new Learning :-)
    Thanks Once again....

    sonbarse Today, 09:32 AM Go to last post
    Pecoflyer

    Hours Between the Days

    NETWORKDAYS.INTL uses a complementary switch (16 in your case) for week ends different from sat/sun . If shifts always end e between start and end hours...

    Pecoflyer Today, 08:14 AM Go to last post
    sonbarse

    Hours Between the Days

    I need to calculate the Total hours an Incident/Ticket been live in system. I have incident login date/time & incident closed date/time.
    Working...

    sonbarse Today, 07:58 AM Go to last post
    arup1032

    How to remove duplicates within a "single cell"

    Use the blow formula:

    =MID(B2&" ",1,FIND(" ",B2&" "))& MID(SUBSTITUTE(B2&" ",MID(B2&"...

    arup1032 Today, 06:10 AM Go to last post
    tejonno

    Recursive table solution

    Here's my attempt, not as elegant as yours cyborgski, but I learnt about recursively passing a table so that was kinda neat......

    tejonno Today, 01:33 AM Go to last post