Do you have an event or meeting that you would like to enter into Excel and have Excel automatically calculate the start and end times of each part of the agenda? You want to have it set up so that you can easily add or remove rows and have Excel automatically recalculate the start and end times. You also want to be able to change the duration of any spot and have Excel automatically calculate the start and end times. This article discusses that.
Click on the screenshot below to enlarge it.
So, there is a lot in this example. The screenshot shows some of the formulas I’ve used.
- Tables
- Table Style Options
- Time (9:00 start time)
- ROW function (A4:A8)
- IF function
- OFFSET function
- SUBTOTAL function (total duration)
- FORMULATEXT function (showing formula in B12:B16)
- Table References (@End)
- Adding and Removing Table rows
- Data Validation (for the Duration column)
- Shapes (for Help and Warning)
- Comment (for entering start time)