Excel Pivot Table

Hello,

I have created a database of employee hours.  From there I created a Pivot Table to summarize the date based on date and Description Code.  This time is coming from customer billing as this is how techs get paid.  So this first table is on a daily basis.

I then have to summarize it even more to get it into a bi-weekly basis.  It is all working smoothly.

What I am having an issue with is a Calculated Field.  It is not giving the result I expect.

What I want is it to break out vaction hours, holiday hours and double time hours.  Vacation and holiday should not be that difficult because there are separate description codes for this.  So I have the following formula... =IF(DCode="VA", Hours,0).  The "hours" should be only those hours for that code, but it is giving me the total of ALL hours.  How do I write the formula so that it gives me just the VA hours?

Double time, I fear, will probably give me another challenge because the DCode is the same as regular hours.  I will need a formula so that it looks at a date, recognizes Sunday and returns just those hours.

Any help will be greatly appreciated and thanks in advance.