I'm using an excel spreadsheet that tracks lessons along with who completes the work and how long it takes. I'm looking for a formula that can sum the time they work based on when their name is selected from a dropdown list. I also need it to take that total and calculate out as to 25% of the total project for that person. I'm trying to track each person productivity on a large project.
Como
I can provide my spreadsheet if you like. Just let me know.
Please put up a spreadsheet
Life's a spreadsheet, Excel!
Say thanks, Click *
Re: Trying to us a dropdown to calculate total time whenever a name is selected.
The speardsheet has multiple tabs and a List tab that has the names I want to track. They are in the SME list. I've also put information in the Development Tab on the first lesson to show what is entered. If you need anything else just let me know thanks.
Como
This thread is solved. Thanks
Welcome to the forum. Its glad to know your problem is solved without any help
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks