| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel time/duration spreadsheet
I am struggling with a spreadsheet listing 50 presentation start and stop
times and duration. I need a formula(s) so when a duration for a presentation changes, the entire spreadsheet's start and stop times change as well. I have used "=IF(A4B4,B4+1-A4,B4-A4)" to calculate the duraction between start and stop, but cannot figure out how to get the rest of the spreadsheet to undate when changed. Any help will be much appreciated!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| putting an excel spreadsheet on a web page | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Is it possible to link an Excel spreadsheet to a Word document an. | Excel Discussion (Misc queries) | |||
| Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
