Ask Your Question
0

Can calc update time changes automatically when a time is changed. (A knock on effect). I am using excel for a hourly time management process system [closed]

asked 2018-01-24 16:39:07 +0100

tommy6141 gravatar image

updated 2020-08-02 11:45:15 +0100

Alex Kemp gravatar image

I would like for a time management system spreadsheet to be able to update time when one change is made. ie: if I change 1 o clock to 2 o clock I would like for the 1 hour change to automatically update the rest of the file

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 11:45:22.450610

Comments

The title is too long, and there are not enough details given in the body of the question. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-01-24 20:16:40 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-24 18:47:31 +0100

erAck gravatar image

updated 2018-01-24 19:57:58 +0100

Let all to be affected calculations depend (directly or indirectly) on the cell in which the time is changed, i.e. add that cell's time or have the cell otherwise appear in the cells' formula expressions. Other than that, your question is unspecific and unclear.

Update from first comment:

  • effective start time A1: =A2+A3
  • regular start time A2: 10:00
  • delay A3: 00:30
  • interval A4: 01:00
  • time slot B1: =A1
  • time slot B2: =B1+A$4
  • time slot B3: =B2+A$4
  • ...

You can copy&paste or pull the formula down as desired.

edit flag offensive delete link more

Comments

I work with a 24 hour spreadsheet that is divided up into hourly slots. If the process is delayed by half an hour at 10 o clock, I would like to update my schedule to 10:30 and then have the times below it to change accordantly automatically.

tommy6141 gravatar imagetommy6141 ( 2018-01-24 19:03:52 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2018-01-24 16:39:07 +0100

Seen: 119 times

Last updated: Jan 24 '18