5 Replies Latest reply: Oct 31, 2012 12:18 PM by laura howarth RSS

    Time interval between two timestamps but except closed hours

    Banjir1848

      Hi I need some help with Time interval between two timestamps. The function give me the interval without any problem

      Sum ([SLA Resolution Time]-interval([Resolve Date]-[Open Date],'hh:mm:ss'))

      But my problem start when working hour is 0700 - 1800 so is there any easy solution so the time between 18;00;01 and 06;59;59 will not be counted in above function?

       

      Thanks in advance