Split Time Range into Half Hour Each Row

[disyn]

I have a data set that look like this

Name	Activity	Detail	Start	Finish
Bob	Cooking	Cooking pasta	22/04/2020 9:00	22/04/2020 10:00
Bill	Reading	Reading novel	22/04/2020 9:30	22/04/2020 10:00

And i want to split it like this

Name	Time	Activity	Detail
Bob	22/04/2020 9:00	Cooking	Cooking pasta
Bob	22/04/2020 9:30	Cooking	Cooking pasta
Bill	22/04/2020 9:30	Reading	Reading Novel

Any excel formula idea or vba macro code idea? Thank you!

 

[DanteAmor]

i inputted the rowsource on combobox properties, like this one

Delete that part and load the combobox with what I put in post #22 and try again.

 

[DanteAmor]

Anyway i have a question, is it possible if i delete a row in the initial table via the userform and then the row in result table also be deleted?

I don't quite understand what you mean, but it is certainly a different topic than this thread, I recommend creating a new thread.

 

[disyn]

Delete that part and load the combobox with what I put in post #22 and try again.

Okay, thank you so much

 

[DanteAmor]

Youre welcome!