Spreading Date per Day

[KamenRider]

Hi,

I am asking for your assistance in helping me out solving date problems. Actually I have a report where date is range and I wanted it to be range per day. If there are dates range by 2 or more days, I would like it be transformed per day, thus it will add more rows to represent per day and number of hours will also change to 8 hours since working hours is 8 per day. Other fields will be copied same. I hope this is possible.

Below is the raw report (which is also being attached)

This should be the results.

Hoping someone to help me this out. Let me know if you have any questions.

Thanks,

Kamen

[KamenRider]

Hi @binuacs 

Thank you for the response. I'll approved this a solution.

Hope to see you again in my next inquiry similar to this.

Kamen

[binuacs]

@KamenRider your latest request is same as this one or different?