Data generation

[Hiteshp]

Hello Team,

From the below input:

Input
Employee	Name	Start Date	End Date	Code	Duration	Dates
1	Ravi	3/10/2025	3/11/2025	Vacation	16	3/10/2025
1	Ravi	3/10/2025	3/11/2025	Vacation	16	3/11/2025
2	Shiv	5/12/2025	5/14/2025	Sick	24	5/12/2025
2	Shiv	5/12/2025	5/14/2025	Sick	24	5/14/2025
2	Shiv	5/12/2025	5/14/2025	Sick	24	5/14/2025
3	Raj	6/11/2025	6/11/2025	Floating	8	6/11/2025

and trying to generate the following output:

Output
Employee	Name	Start Date	End Date	Code	Duration	Dates	Actual Duration
1	Ravi	3/10/2025	3/11/2025	Vacation	16	3/10/2025	8
1	Ravi	3/10/2025	3/11/2025	Vacation	16	3/11/2025	8
2	Shiv	5/12/2025	5/14/2025	Sick	24	5/12/2025	8
2	Shiv	5/12/2025	5/14/2025	Sick	24	5/14/2025	8
2	Shiv	5/12/2025	5/14/2025	Sick	24	5/14/2025	8
3	Raj	6/11/2025	6/11/2025	Floating	8	6/11/2025	8

[CoG]

There isn't a question here. What process are you using that you need assistance with? Just based off of what was provided, A Formula Tool with hard-coded value of 8 will get you from provided input to output.

[Hiteshp]

Using Generate Row Tool i was able to split the Dates as per Start and End Date, however in the first table if a entry is for 3 day the duration show 24.. i need to split it again as 24/3 which should give me 8 hours per day if it for 2 day and the duration is 16.. it should give me 16/2 so 8 hours each date.

[binu_acs · Accepted solution]

@Hiteshp one way of doing this with the help of summarise tool and join tool

[CoG · Accepted solution]

Since you are Generating Rows and already have the Start Date and End Date in the data, you can utilize that without needing to Summarize: