0 Replies Latest reply: Sep 22, 2015 4:40 AM by Viktoria Blomqvist RSS

    Interval between timestamp with no holiday



      I have log_from and Log_to and I have done an timestamp interval, my problem is the NetWorksdays is one day I want to excluding the time for I have in holiday in my calculation.


      Log_From                        Log_to                           Interval                  I want to have

      2009-08-21 10:54:16       2009-08-26 13:42:43     05 - 02:48:27       3 - 02:48:27


      It log_from is on a Saturday I want to excluding only the time not the all day.


      Cheers Viktoria