How to split one data in a cell into several cells?

[LeiCheng]

Hi, I am sure if I stated my question clear enough. I have a list of person, and want to let them have a standard 8 hrs per day utile the final one is equal to or less than 8 hrs. Like below. I use Generate Rows to give them a calendar date for each row. But cannot go further to split the hrs. Can anyone meet the same situation and find the resolve it? Many thanks.

[benakesh · Accepted solution]

Hi @LeiCheng ,

Attached wf produces expected results  .  If it helps please mark it as  solution .  

[LeiCheng]

@benakesh, You are a genius! Many thanks for your perfect solution.

[fmvizcaino]

Hi @LeiCheng ,

Attached is a solution for your problem.

I developed two ways of doing it, one by inserting the half hour and other ignoring it.

Let me know if that works for you.

Best,

Fernando Vizcaino

edit: Omg, I think I didn't refresh my browser for the past half hour. My bad!!!

Great solution @benakesh