0 Replies Latest reply: May 1, 2014 12:19 PM by Fernando Barros RSS

    How to split timestamp in work days



      I´m openning a new post since I made some confuse.


      For example. I have a interval date:

      Start date:28/04/2014 15:31:00

      End Date: 30/04/2014 08:43:00


      I would like to have this result, which means all the work days from 09:00 until 18:00.


      24128/04/2014 15:3128/04/2014 18:00
      24228/04/2014 09:0029/04/2014 18:00
      24329/04/2014 09:0029/04/2014 08:43


      I was trying to see this Splitting the data - On the way to granularity, but I couldn´t make in my way.


      Any help would be appreciated.


      Best Regards