Roger, That did not seem to work. Maybe a little more information would help.

I believe the challenge is the in the way pivot tables summarizes the
multiplies.

For example

10/1/05 task 1 = 2.00 hours
10/1/05 task 2 = 3.00 hours
10/3/05t task 3 = .50

rate 50.00/hour

thus,(2.00+3.00+.50=5.5 * 50.00) * 3


Instead what i am looking for in the above example is 5.5 hours *50.00/hr.

Any idea, how i can accomplish this?
thanks


Jerry
"Roger Govier" wrote:

Hi Terry

Excel stores hours as fractions of a day, so multiply Hours * 24 * Bill Rate

Regards

Roger Govier


jerry wrote:
I am querying an external database to retrun a pivot table, then i am adding
a calculated field that calculates Regular hours * Bill rate. to come up
with total revenue. When it runs, the calculated amounts are 2, 3, 4 times
more that what it should be.

any ideas how i can get this calculation to return the right amounts.

thanks
Jerry