| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting hours spent by a team per project
On Thu, 28 May 2009 01:33:01 -0700, The Fool on the Hill
wrote: Hello Excel(lent) users, I want to count the hours that are spent by a particular team on a particular project. Could you please help me ? In Column C I have the ID of the project In Column H I have the ID of the team The Hours I have in Column J Could you give me a formula to help me solve this ? Thank you very much !! Assuming that you will have multiple lines per team/project, you could use a Pivot Table. Do something like Drag teams to Rows Drag projects to Columns Drag hours to the Data or Value area --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of hours per project per team | Excel Discussion (Misc queries) | |||
| Calculating hours spent per team | Excel Discussion (Misc queries) | |||
| Creating a formula to display # of work hours spent on a project | Excel Discussion (Misc queries) | |||
| Running Total for Time Spent for a project in 1 month | Excel Worksheet Functions | |||
| How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions | |||
Threaded Mode
