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

Jo,

You would need to re-write your formula to allow for row insertion. For example, if your formula is
in cell B4, and is this

=B3 + C3/1440

then rewrite it as

=OFFSET(B4,-1,0)+OFFSET(C4,-1,0)/1440

HTH,
Bernie
MS Excel MVP


"Need_to_Know" <u33457@uwe wrote in message news:70e4508e26884@uwe...
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

Hi Again,

thanks for your last response however, I think I may be doing something wrong
as this hasn't worked yet.

=B6+TIME(0,C6,0) this is my current formula.

and I have tried entering OFFSET at various locations, but i keep getting an
error message.

Help? please...



Need_to_Know wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200705/1