Adjust Time in Cells Automatically

stevembe

Well-known Member
Joined
Mar 14, 2011
Messages
501
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.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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
ABC
19:009:3030
29:309:4010
39:4010:0525
Sheet2
Cell Formulas
RangeFormula
B1=A1+(C1/1440)
B2=A2+(C2/1440)
B3=A3+(C3/1440)
A2=B1
A3=B2
 
Upvote 0
Try
Where the length of the visit is in column C in minutes. This is need to know how to adjust the finish times.

ABC

<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
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top