• MVP Logo
  • Recent Forum Posts

    sonbarse

    Hours Between the Days

    Hi.
    The above formula only works if the ticket is closed next working day. If the ticket is aged for say 4 days, the formula gives incorrect output....

    sonbarse Yesterday, 03:45 PM Go to last post
    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 Yesterday, 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 Yesterday, 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 Yesterday, 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 Yesterday, 06:10 AM Go to last post