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?

		Start Time		End Time		Delay between events
Event 1		STEvent1		EtEvent1		N/A
Event 2		StEvent2		EtEvent2		=EtEvent1-StEvent2
Event 3		STEvent3		EtEvent3		=EtEvent2-StEvent3

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

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).