Problem with Calculated Fields in a Pivot Table

[JimRoy]

I apologize in advance if this questions has already been asked or I am improperly posting. This is one of my first posts so hang with me please.....

I have a very simple excel pivot table with three columns:

Name	Actual Hrs	Max Hrs
Smith, Bill	42.00	40.00
White, Betty	39.00	40.00

I wish to add a calculated field to display Over Time hours. I have followed the instructions to the add a calculated field but I get this error message. What the heck am I doing wrong?

 

[Cubist]

Well I just resolved the problem. I went back to the original table and changed the name of the HoursActual column header to just Hrs and bingo. Problem resolved! Go figure?

Glad you figured it out. That was strange that it's insert 'Hour which wasn't on your list.

 

[JimRoy]

Reply back so I can give you credit for the solution. That is where you were taking me.

 

[JimRoy]

Glad you figured it out. That was strange that it's insert 'Hour which wasn't on your list.

Sure was. I spent HOURS of my life I will not get back!!! Thanks for your help Cubist.