Splitting dates into rows

[joannasokolowska]

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

[Emil_Kos]

Hi @joannasokolowska,

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!

[PhilipMannering · Accepted solution]

Hi @joannasokolowska 

Perhaps the below solution has what you need,

[joannasokolowska]

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. 

[Qiu]

@joannasokolowska 
Let me give a try.