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

    Interval between timestamp with no holiday

    Viktoria Blomqvist

      Hi,

       

      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