I am trying to work out how to create a formula to make a plan showing when a total process will be finished and also each stage start and finish times. The time for each stage is fixed, but the initial start time may vary and the process in total will span 3 days.

I am happy on how many minutes it takes from the start to finish, but am struggling to add this to a date.

For example

Stage 1 was started at 0700 on the 18th of Nov and it takes 60 mins so finished at 0800 on the 18th of November

Stage 2 can only start when 1 is finished so it starts at 0800 and takes 24 hours (1440 mins) so should finish on 19th of November at 0800.

Stage 3 takes 12 hours (720 mins) so will finish at 2000 hours on the 19th.

I want the once cell to have both the start cells and the finish cells to have the date and the time in it based on the duration of the stage before.

Stage | Start | Duration | Finish |

1 | 0700 18-11-18 | 60 | 0800 18-11-18 |

2 | 0800 18-11-18 | 1440 | 0800 19-11-18 |

3 | 0800 19-11-18 | 720 | 2000 19-11-18 |

<tbody>

</tbody>

Hope this makes sense