Piviot Formula

[Adam]

Hi I'm using a pivot chart to calculate employee OT

Example

File # Week 1 Week 2
19024 5 3
19024 0 6
19024 18.5 0
19024 8.5 9
19024 20.25 25.25

File # : Represents the Employee
Week 1: Represents the the hours at worked at different locations
Week 2: Represents the the hours at worked at different locations

This is the formula I am tring to use with no results:

=IF('File #','Week 1' >40,'Week 1' -40)+(IF('File #','Week 2' >40,'Week 2'
-40))

Please Help