How do you substract 2 cells based on its location

[Paul Naylor]

Hoping someone can help. I'm wanting a dynamic function that will subtract one cell from another based on the locations I specify

E,g,

I've got a list of times in column A , but want to be able to subtract different cells by specifying their locations , so I have 2 random cells e.g H5 & H6 and want to be able to specify say cell A6 in H5 and cell A20 in cell H6 ang have a formula which say subtracts the values of my selections .

Hope I've explained it well enough ?

 

[Kaper]

If you want to subtract cells which addresses are written in other cells use INDIRECT function.

like:

=INDIRECT(H5)-INDIRECT(H6)