I am using Excel 2003 and have a project in which I need to calculate the
number of hours worked per category, per employee, per day. For example:
one category I have named W110 (label is "HR") and throughout one day this
particular employee had at various times of the day performed some function
of HR and at other times dedicated their time for other different categories.
How do I insert a formula that will tell me the information I need? Please
help as I have many days and employees that I have to oranize their
information to put in a report for the Big Wigs.
Thank you for your time!

Check out "PIVOT TABLES" in the Help Menu: They take some "trial and
error" to get exactly what you want. But since they use the data from
the spreadsheet - your only part is to place the columns and rows so
you get the data "you want." Once you have what you want then you can
select the DATA area of the PIVOT TABLE to either SUM, COUNT, AVERAGE,
etc. "PIVOT TABLE" is located under DATA on the menu bar.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=501388