I think I would just use the cell references as the formula is much simpler, but would this suffice if you really want to use the named ranges?
D2 would house a manual "N/A"
D3 copied down.
Delay
| A | B | C | D |
1 | Event | StarTime | EndTime | Delay |
2 | 1 | 10:00 | 11:00 | N/A |
3 | 2 | 11:05 | 11:15 | 0:05 |
4 | 3 | 11:30 | 12:10 | 0:15 |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:51px;"><col style="width:71px;"><col style="width:70px;"><col style="width:52px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas |
Cell | Formula | D3 | =INDEX(StartTime,ROWS(D$1:D3)-1)-INDEX(EndTime,ROWS(D$1:D3)-2) |
<tbody>
</tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4