Looping multiple connectors

[wags1]

Hello,

I am trying to 'loop' two connectors - is there a way to do this within Alteryx? 

Essentially I have a dataset where I need to add time based on the previous row (which I've done in the multi row formula connector), however the following row is based on the calculation from the current row, so in order to get this to work I could repeat the two connectors multiple times but I am hoping there is a much smarter way to do this.

Workflow attached as well as my example input and output spreadsheets to help show what I'm trying to do in case my description isn't overly clear.

Any help would be really appreciated!

Thanks

Example output:

Example output showing formulas:

[Warcry · Accepted solution]

Use two multi-row formulas: 

1. Formula: IF [Flag] = "FIRST" THEN [Depart_midnight] ELSE [Row-1:depart_updated] endif

2. Formula: IF [Flag] = "FIRST" THEN [Depart_midnight] + [travel_time]ELSE [Row-1:depart_updated] + [travel_time] endif

[Warcry]

If this solves it, please accept my answer as the solution, thank you.

[wags1]

Thanks Warcy for the reply. I must still be doing something wrong as when I put those in, it only calculates for the second row in the sequence. Would you mind sharing your workflow so I can troubleshoot mine?

[Warcry]

Make sure your columns that you want to add are not string columns.