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.
|24||1||28/04/2014 15:31||28/04/2014 18:00|
|24||2||28/04/2014 09:00||29/04/2014 18:00|
|24||3||29/04/2014 09:00||29/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.