Forum Discussion
Teresa1400
Mar 09, 2021Copper Contributor
set up a live agenda in a worksheet
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 ...
mathetes
Mar 09, 2021Silver Contributor
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
- Teresa1400Mar 10, 2021Copper ContributorThanks, I'll check them out!