QUESTION: Hi!

I have a spreadsheet with a column with a staff member and another column next to this one with time spent on a specific task.
I need to calculate working ours for every staff member on a specific date.

ANSWER: This is a perfect job for a PIVOT TABLE. You can easily add up the times and group them by staff members. It's too much to go into detail here, but if you google "excel pivot tables" I'm sure you'll find a million tutorials on them.

I cover them myself in my Excel 223 tutorial:

http://www.599cd.com/site/courselist/excel/excel223?key=BlFAlEx

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT EXCEL VIDEO TUTORIAL. Go to http://www.599cd.com/Excel/AllExperts


Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Excel Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

I hope this information helps to solve your problem. If there is ANY REASON why you won't give me a RATING of 10 please let me know so I can improve upon my answers in the future. Thank you!

Sign up for my FREE NEWSLETTER with lots of TIPS and TRICKS. Visit http://www.599cd.com/MailingList?key=BlFAlEx

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=BlFAlEx

---------- FOLLOW-UP ----------

QUESTION: Hi,
Can I use pivot tables when I have more than one heading/different tables and in different sheets?
See example attached!
Thanks ;)

---

Answer from Richard Rost:

Yes, you can. You might need to consolidate some of that information into a single sheet with copy and paste (link) but you can bring different areas together into a single PT. It just takes a little more work.