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!