Calculate total hours worked, between two dates (start and finish)

[nsweetman]

I have a product line consisting of 4 resources (A,B,C,D) and the hours per day (averaged) they do. These columns have varying hours depending on dates. I have an on the spot date where i want to know how many hours of A,B,C,D (seperately) will be used per day. I have over 1000 "on the spot" dates i need to check. I've been trying to use SUMIFS but had no luck.


Start_Date -- Finish_Date --- A -- B -- C-- D
01/01/2011 -- 01/03/2011 -- 10-- 5 -- 4 -- 3
10/02/2011 -- 10/05/2011 -- 7 -- 6 -- 2 -- 1
15/02/2011 -- 10/05/2011 -- 8 -- 7 -- 2 -- 2

[Pepe Le Mokko]

What are your regional settings?

[nsweetman]

Not sure what you mean. I havent changed anything.

[Pepe Le Mokko]

Are the dates mm/dd/yyyy or dd/mm/yyyy?

[nsweetman]

. The last start date proves dd/mm/yyyy