Need help in splitting rows

[HBarge]

Hi,

I have this example dataset of employees with timesheets

A few of the employees work through one claendsar day to the next calendar day (Night shift)

I would like to represent them in 2 rows

i.e. 

Date	Emp Code	Name	Activity Codes	Start Date Time	Stop Date Time	Unadjusted Shift Length (Hours)	Start Day	Finish Day
22/02/2015	10115	RAPONI Daniela		22/02/2015 16:00	23/02/2015 6:00	14	Sunday	Monday

to

Date	Emp Code	Name	Activity Codes	Start Date Time	Stop Date Time	Unadjusted Shift Length (Hours)	Start Day	Finish Day
22/02/2015	10115	RAPONI Daniela		22/02/2015 16:00	23/02/2015 12:00	8	Sunday	Sunday
23/02/2015	10115	RAPONI Daniela		23/02/2015 0:00	23/02/2015 6:00	6	Monday	Monday

How can I accomplish this?

The example dataset attached has more than one examples.

Thanks,

Harshad

[RolandSchubert · Accepted solution]

Hi @HBarge ,

I think, splitting the rows using a Filter tool and Formula tools should be the solution. I've attached a sample workflow.

Let me konw if it works for you.

Best,

Roland