Results 1 to 4 of 4

Thread: Adjust Time in Cells Automatically
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2011
    Posts
    499
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Adjust Time in Cells Automatically

    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.

  2. #2
    Board Regular Scott T's Avatar
    Join Date
    Dec 2016
    Posts
    2,527
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adjust Time in Cells Automatically

    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

    Sheet2



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

    Colonel Sandurz: Prepare ship for light speed.
    Dark Helmet: No, no, no, light speed is too slow.
    Colonel Sandurz: Light speed, too slow?
    Dark Helmet: Yes, we're gonna have to go right to ludicrous speed.

  3. #3
    Board Regular
    Join Date
    Mar 2011
    Posts
    499
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adjust Time in Cells Automatically

    Quote Originally Posted by Scott T View Post
    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
    1 9:00 9:30 30
    2 9:30 9:40 10
    3 9:40 10:05 25
    Sheet2

    Worksheet Formulas
    Cell Formula
    B1 =A1+(C1/1440)
    A2 =B1
    B2 =A2+(C2/1440)
    A3 =B2
    B3 =A3+(C3/1440)
    That works perfectly, thank yo so much

  4. #4
    Board Regular Scott T's Avatar
    Join Date
    Dec 2016
    Posts
    2,527
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adjust Time in Cells Automatically

    You are welcome
    Colonel Sandurz: Prepare ship for light speed.
    Dark Helmet: No, no, no, light speed is too slow.
    Colonel Sandurz: Light speed, too slow?
    Dark Helmet: Yes, we're gonna have to go right to ludicrous speed.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •