Comparing values within a named range

[JamesMac]

Hi,

I am learning about named ranges.

I have a set of records that provides information about when an event starts and ends.
There are multiple events that occur within a day.
I need to determine what the delay was between each event.
See the table below for an example.
The named ranges are: "Start Time", "End Time" and "Delay between events".
Without Named ranges, I simply used standard row/column references.
How do I write a formula that subtracts a named range in one event, from a named range in another event?

[TABLE="width: 502"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Start Time[/TD]
[TD] [/TD]
[TD]End Time[/TD]
[TD] [/TD]
[TD]Delay between events[/TD]
[/TR]
[TR]
[TD]Event 1[/TD]
[TD] [/TD]
[TD]STEvent1[/TD]
[TD] [/TD]
[TD]EtEvent1[/TD]
[TD] [/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]Event 2[/TD]
[TD] [/TD]
[TD]StEvent2[/TD]
[TD] [/TD]
[TD]EtEvent2[/TD]
[TD] [/TD]
[TD]=EtEvent1-StEvent2[/TD]
[/TR]
[TR]
[TD]Event 3[/TD]
[TD] [/TD]
[TD]STEvent3[/TD]
[TD] [/TD]
[TD]EtEvent3[/TD]
[TD] [/TD]
[TD]=EtEvent2-StEvent3[/TD]
[/TR]
</tbody>[/TABLE]


Any insights would be much appreciated.
Thank you,
Jim

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1050000-reference-cell-named-range.html#post5041608

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).