Excel Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 an
error" to get exactly what you want. But since they use the data fro
the spreadsheet - your only part is to place the columns and rows s
you get the data "you want." Once you have what you want then you ca
select the DATA area of the PIVOT TABLE to either SUM, COUNT, AVERAGE
etc. "PIVOT TABLE" is located under DATA on the menu bar
 
Back
Top