set up a live agenda in a worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2196388%22%20slang%3D%22en-US%22%3Eset%20up%20a%20live%20agenda%20in%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2196388%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20an%20agenda%20that%20I%20can%20update%20as%20timing%20is%20adjusted%20throughout%20the%20day.%26nbsp%3B%20For%20example%3A%3C%2FP%3E%3CP%3Eif%20a%20topic%20is%20due%20to%20be%20spoken%20of%20at%2014%3A30%20for%2020%20minutes%2C%20but%20it%20goes%20over%20by%205%20minutes%2C%20I%20need%20to%20update%20the%20new%20start%20time%20and%20adjust%20the%20duration%20of%20the%20next%20topic%20that%20was%20supposed%20to%20happen%20at%2014%3A50%20for%2030%20minutes.%26nbsp%3B%20It%20will%20now%20happen%20at%2014%3A55%20for%2030%20minutes%20and%20therefore%20affect%20the%20rest%20of%20the%20pre-set%20daily%20agenda.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20similar%20to%20adding%20a%20day%20to%20a%20cell%20and%20then%20copying%20that%20formula%20to%20subsequent%20cells.%26nbsp%3B%20When%20I%20change%20the%20initial%20date%2C%20all%20other%20are%20adjusted%20as%20a%20consequence.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20finding%20this%20more%20challenging%20than%20I%20expected%2C%20but%20there%20must%20be%20a%20simple%20answer.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2196388%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am trying to create an agenda that I can update as timing is adjusted throughout the day.  For example:

if a topic is due to be spoken of at 14:30 for 20 minutes, but it goes over by 5 minutes, I need to update the new start time and adjust the duration of the next topic that was supposed to happen at 14:50 for 30 minutes.  It will now happen at 14:55 for 30 minutes and therefore affect the rest of the pre-set daily agenda.  

Its similar to adding a day to a cell and then copying that formula to subsequent cells.  When I change the initial date, all other are adjusted as a consequence.  

I am finding this more challenging than I expected, but there must be a simple answer.  

 

2 Replies

@Teresa1400 

 

I think you just need to learn how to reference time and do time calculations. Here are several links that should point you in the right direction.

https://exceljet.net/excel-functions/excel-time-function

https://exceljet.net/formula/add-decimal-hours-to-time

https://exceljet.net/formula/add-decimal-minutes-to-time

 

Thanks, I'll check them out!