M
Mark
I have a table as belowfor employee hours. I sumarize
hours a week at a time and I need summaries by employee,
total straight time and total overtime for the week.
I am trying to use a pivot table.
Name Type 1/1/04 1/2/04 1/3/04
J S ST 8 8 8
J S OT 2 2 2
H B ST 2 2 2
H B OT 2 2 2
I want the output to look like . . .
J S Total ST 40
J S Total OT 10
J S Total 50
How do I set up the table?
What Pivot Table report do I use?
Thanks
hours a week at a time and I need summaries by employee,
total straight time and total overtime for the week.
I am trying to use a pivot table.
Name Type 1/1/04 1/2/04 1/3/04
J S ST 8 8 8
J S OT 2 2 2
H B ST 2 2 2
H B OT 2 2 2
I want the output to look like . . .
J S Total ST 40
J S Total OT 10
J S Total 50
How do I set up the table?
What Pivot Table report do I use?
Thanks