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
Solved! Go to 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