Split a date according to periods

Hi protonLeah


At the start of each month I need to set a time for a comprehensive system of work for each agent.

Meanwhile, in the course of the month, sometimes an agent to take a rest, defined as a period with a start date and an end date.

Then the table contained only two line (two periods), will increase by an additional line, because the overall period shall be divided by the period of rest.

Thank you.

Hi,

One approach to give a try?