difference in hours

Hi all,

I need something that compares column A with E (V-lookup) and the outcome needs 2 be the difference in hours between B,C and F,G!


i hope that you guys understand my question. sorry for the bad english.
kind regards
Kevin

An attachment with the values in would make life easier. they are presumably separate lists and values can only appear in each list once.


if the value was to go in D1 vlookup(a1, e1:g100,2,false)+vlookup(a1, e1:g100,3,false)-b1-c1