Hey Guys,
I need your advice regarding possible solutions for what I try to achieve 🙂
This is what I have in the file:
User | Course | Start Day | End Day |
John | A | 30/07/2021 09:00 | 30/07/2021 09:40 |
John | B | 02/08/2021 09:00 | 03/08/2021 15:00 |
John | C | 05/07/2021 09:00 | 07/07/2021 16:00 |
What I would like to see (If there is a different start day/end day - not hours)
User | Course | Start Day | End Day |
John | A | 30/07/2021 09:00 | 30/07/2021 09:40 |
John | B | 02/08/2021 09:00 | 02/08/2021 15:00 |
John | B | 03/08/2021 09:00 | 03/08/2021 15:00 |
John | C | 05/07/2021 09:00 | 05/07/2021 16:00 |
John | C | 06/07/2021 09:00 | 06/07/2021 16:00 |
John | C | 07/07/2021 09:00 | 07/07/2021 16:00 |
Thank you in advance!
Asia
Solved! Go to Solution.
I have prepared a solution for you.
First of all, I have prepared new columns with the proper date-time format and then I used to generate a tool in order to create new lines.
If this was helpful for you please mark it as a solution!
Hey,
Thank you for a quick response 🙂 I just checked your workflow and it doesn't work as expected 😕
in your solution I still see different date for start and end date (it should be the same date for both - different hours) and I want to split this date range to have each date in new row.
@joannasokolowska
Let me give a try.