• MVP Logo
  • Recent Forum Posts

    claromatt

    Using ROUNDUP with an existing formula

    Hello! This is my first post, and I'd like to start by thanking this forum for existing!
    I am an absolute beginner with Excel, so I feel a bit underwater…especially...

    claromatt Today, 01:03 AM Go to last post
    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