How to split timestamp in work days

[#1]

Hi,

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.

lState	ShiftID	TZStart	TZEnd
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.

Best Regards

Fernando