Excel Pivot Table Results does not Calculated as Expected

[jfussell]

Hi, this is probably a very easy question with an easy solution, but I can't seem to get my calculations to work.
I have a database spreadsheet that lists Customer, Project, Name of Employee, Date worked, Work Duration and Department. I want to create a pivot table that lets me know how many hours each department spends on each customer and project. I was able to successfully create the pivot table, however instead of calculating the total hours each department had put in, it's calculating each entry each employee has made.

Here's a bit more detail of my pivot table:
Column A is Customer
Column B is Project
Column C~E are the departments...admin, engineer, Sales/Marketing
Column F is the Grand Total

Each row lists the different Customer and corresponding projects.

Example, for one project, the Admin had put in 6.5 hours into it, but instead of calculating the sum of hours per project of 6.5 hours, it's calculating the 2 separate entry rows and lists 2 on the pivot table. Under field settings, I've tried changing the "summarized by count" to summarized by sum", and it still shows incorrect calculations. I hope I had explained this in enough detail to get some help to solve this problem. Thanks.

 

[xlbo]

Sounds like it should be ok
Having problems visualising the layout though
Can you go to the layout page of the wizard and tell me what is in the
PAGE field, ROW fields, COLUMN fields and the VALUE field
in the format of
PAGE: Item 1, Item 2
ROW: Item 3, Item 4 etc etc

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[jfussell]

Actually, it was even easier than I had imagined. After I submitted this question, I had to kick my own butt for not thinking of this prior.

First of all, it was giving me a count instead of sum, which after I changed that, under the same popup, I select number/custom and chose [h]:mm. After that everything fell into place and the total came out as expected. Can't believe that little feature threw everything off so much. Sorry to bother you with this and thanks for your attempt to help me. I've really appreciated your posts in the past.

 

[xlbo]

No probs - thanks for posting back the solution. Should help if anyone else finds themselves in a similar situation

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244