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