Separate Rows in to days based on Start and end date/time

Hi rtillery2000,

Please check out the demo here. 

1. Add a custom column like this.

{Number.From([StartDate])..Number.From([EndDate])}

2. Expand the custom column.

3. Change its type to Date. (not datetime).

4. Add a new column "NewStart".

if ( [Temp] = [StartDate]) then [StartTime] else [Temp]

5. Change its type to datetime.

6. Add a new column "NewEnd".

if ([Temp] = [EndDate]) then [EndTime] else [Temp] & #time(23,59,59)

7. You can delete the old two columns. 

Best Regards,

Dale