5 Replies Latest reply: Sep 24, 2011 2:01 PM by Stefan Wühl RSS

    Working days hour calculation with non working days (Sat and Sun)

    Anand Chouhan

      Hi,

       

      I have a Query i think it is so easy but i am stuck on it little bit I use Interval match on that it works but not perfectly.

      Query is i want to calculate work hours between two times Start and End, i am able to calculate hour difference but not accurate see sample example like

       

       


      MON-FRISATSUN
      A0:154:000
      B02:000
      C2:0000
      D05:000
      E00:485:00
      F005:00

       

      EXAMPLE:-

       

      STARTEndDIFFFRI TimeSat Time
      9/23/201111:45:00 PM 9/24/20114:00:00 AM4:15:0000:15:004:00:00

       

       

      How to calculate this please provide details

      See my sample file.

       

      Rgds

      Anand