14 Replies Latest reply: May 2, 2014 8:18 AM by Fernando Barros RSS

    Splitting the data in Work Hours & Days



      I´ve trying this for several days, but I´m a newbie yet. I would like to split my data in work days.


      For example. I´ll have:

      Início do período (Start date) - 7/11/2013 11:10:00 am

      Fim do período (End date) - 7/15/2013 10:20:00 am


      I would like to have the interval of time excluding non working hours and sunday

      7/11/2013  - consider only 11:10am to 6pm +

      7/12/2013  - consider only 9am to 6pm

      7/13/2013 - consider only 9am to 6pm

      7/14/2013  whole 24hrs should be excluded

      7/15/2013 consider only 2am to 10:20am


      I tried this solution Splitting the data - On the way to granularity, but this is splitting in time zones. I could not make this in work days. I´ll need to transform this interval above ( 7/15/2013 10:20:00 am, 7/11/2013 11:10:00 am) in several days considering work hours)


      Any help would be appreciated.