| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating hours spent per team
Dear Excel(lent) users,
I have a challenge, which I would like to share with you: I am managing multiple projects and have multiple teams working on these projects. I want to know how much time is spent on what project by what team. Column A = Project Column B = Team (e.g. team 1, team 2, team 3, team 4) Column C = number of hours spent Can you please give me formula which gives me the desired information? Thank you kindly !! Jaydubs !! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a formula to display # of work hours spent on a project | Excel Discussion (Misc queries) | |||
| summing up hours spent on jobs | Excel Discussion (Misc queries) | |||
| Team Role Rotation (number of team members is variable) | Excel Worksheet Functions | |||
| how do I calculate hours spent x an hourly rate? | Excel Worksheet Functions | |||
| How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions | |||
Threaded Mode
