find out how many hours each person will spend on a project during the year

[annieflanz]

Hello,

I'd love to pick someone's brain about how to accomplish what I need to do. I've got an excel sheet that calculates the number of hours per week that each of member of my team at work needs to spend on a certain project. I'd like to use this sheet to find out how many hours each person will spend on a project during the year. I'd rather not post the spreadsheet to the Internet, so if anyone's willing to help I'd be happy to email you the sheet and continue the conversation via email. Any help would be much appreciated!

- annie

[oeldere]

Why not make a dummy sheet, without confidentional information.

Then you can get answers of all forum members.

[annieflanz]

Good idea! Here it is!

[kvsrinivasamurthy]

Pl see the attached file. Formulas are available at rows 441 to445.