Multi-row formula - subtract hours from a start date

[bchen1]

Hi - I have a dataset structured like the table below where I have products that need to go through a set of processes with various cycle times. I'm looking to create a multi-row formula/tool that groups by the Product and gives the LatestStartTime for each process, working back from the EndDate and the prior process. In the "LatestStartTime" I show the desired output.

Product	Process	EndDate	HoursInProcess	LatestStartTime (DESIRED OUTPUT)
ProductA	Process1	1/31/2023	48	1/26/2023
ProductA	Process2	1/31/2023	48	1/28/2023
ProductA	Process3	1/31/2023	24	1/30/2023
ProductB	Process1	1/31/2023	24	1/22/2023
ProductB	Process2	1/31/2023	24	1/24/2023
ProductB	Process3	1/31/2023	24	1/26/2023
ProductB	Process4	1/31/2023	72	1/28/2023

Thanks for any advice/input here!

[ArtApa]

Hi @bchen1 - Please see a possible solution below:

[Raj]

Great logic  !