Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of hours per project per team
Hello Excel(lent) users,
I am stuck with a challenge, which I wanted to share with you ! I am managing multiple projects, which are executed by multiple teams. I want to keep track of the hours spent per team per project. I want to get that information from the following columns: Column A Project identification (project 1, Project 2, Project 2, etc) Column B Name of executing team (Team 1, Team 2, Team 3, etc) Column C Number of hours spent The display should be in a new tab: Project Team # of hours PR 1 Team 1 PR 2 Team 2 PR 3 Team 3 PR 4 Team 4 Can you please help me out ? Thank you very much for helping me out !! Jaydubs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating hours spent per team | Excel Discussion (Misc queries) | |||
Calculate number days + hours to complete a project | Excel Worksheet Functions | |||
Team Role Rotation (number of team members is variable) | Excel Worksheet Functions | |||
How to project the due date according to a number of working hours | Excel Discussion (Misc queries) | |||
How to project the due date according to a number of working hours | Excel Worksheet Functions |