I am trying to create a template for meeting agendas in excel, so than when I
enter the time and duration in the first line, after inserting a formula in
the second line it calculates the time for the start of the next activity.

e.g. Start 0:800 Duration: 15 next start time calculated is 0:815
08:15 Duration: 20 next start time calculated is
08:35
and so on...
I just copy the formul down and everytings fine. However if I need to make a
change like insert an additional break in the days programme, the formula
doesn't copy, so i have to drag the formula all the way down again.

For a few rows this is ok, but it causes issues for many rows. Therefore is
there another way to insert a row so the formula doesn't break? or need to be
re-copied all the way down?

Any help will be greatly appreciated.
thanks
Jo