Start and Finish times depending on duration changes

[Samantha_Blunden]

Hello,

I am trying to create a formula which will automatically calculate the start and finish times of board meeting items.

I have provided a snap show below of what I would want this to look like. however I am trying to get the start and finish times to automatically update for each item should there be a change to the duration of the item.

Does anyone know how to do this?

I am using Excel 2016.

Thanks so much!

 

[Saba Sabaratnam]

Hi

Enter the meeting start time in C3

Enter the following formula in D3 and copy it down
=C3+(B3/(24*60))

Enter the following formula in C4 and copy it down

=D3

Kind regards

Saba

 

[Samantha_Blunden]

Hi

Enter the meeting start time in C3

Enter the following formula in D3 and copy it down
=C3+(B3/(24*60))

Enter the following formula in C4 and copy it down

=D3

View attachment 42496

Kind regards

Saba

thank you so much!!! you have no idea how much time this will save me!!!

 

[Saba Sabaratnam]

No problem