# Adjust Time in Cells Automatically

#### stevembe

##### Well-known Member
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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### Scott T

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

#### stevembe

##### Well-known Member
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
19:009:3030
29:309:4010
39:4010:0525

</tbody>
Sheet2

Worksheet Formulas
CellFormula
B1=A1+(C1/1440)
A2=B1
B2=A2+(C2/1440)
A3=B2
B3=A3+(C3/1440)

</tbody>

<tbody>
</tbody>
That works perfectly, thank yo so much

You are welcome