Adjust Time in Cells Automatically

[stevembe]

Thank you for taking the time to read.

I put together a lot of visit timetables and my issue is they constantly change. For example a visit can start in cell A1 at 09:00 with that section due to finish in cell B1 at 09:20. The next part of the visit could be from cell A2 at 09:20 to cell B2 at 10:00 and so on. At he moment if timings change I am constantly changing the times manually. Is there a way of adjusting the times automatically so if for example a visit that was due to start at 09:30 changes to 10:00 then all following time slots would be adjusted accordingly?

Quick example:

Start cell A1, finish cell B1

Item 1: Start at 09:00 Finish at 09:30
Item 2: Start at 09:30 Finish at 09:40
Item 3: Start at 09:40 Finish at 10:05

If the timings change back or forwards automatically update all the following time slots. So if the start time where changed to 08:30 in A1 then all the other times would update.

Really would appreciate any advice.

 

[Scott T]

Try
Where the length of the visit is in column C in minutes. This is need to know how to adjust the finish times.

Book1
	A	B	C
1	9:00	9:30	30
2	9:30	9:40	10
3	9:40	10:05	25
Sheet2

Cell Formulas
Range	Formula
B1	=A1+(C1/1440)
B2	=A2+(C2/1440)
B3	=A3+(C3/1440)
A2	=B1
A3	=B2

 

[stevembe]

Try
Where the length of the visit is in column C in minutes. This is need to know how to adjust the finish times.

	A	B	C

<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]9:00[/TD]
[TD="align: right"]9:30[/TD]
[TD="align: right"]30[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]9:30[/TD]
[TD="align: right"]9:40[/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]9:40[/TD]
[TD="align: right"]10:05[/TD]
[TD="align: right"]25[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=A1+(C1/1440)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A2[/TH]
[TD="align: left"]=B1[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=A2+(C2/1440)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A3[/TH]
[TD="align: left"]=B2[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B3[/TH]
[TD="align: left"]=A3+(C3/1440)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

That works perfectly, thank yo so much

 

[Scott T]

You are welcome