MHSchutzy
New Member
- Joined
- Jan 3, 2023
- Messages
- 1
- Office Version
- 365
- 2021
- Platform
- Windows
- MacOS
- Mobile
I'm working to build a new timesheet that can help automatically breakdown time to respective projects. Some staff will always input exactly what project they are working on as it changes for them, but others will always work on the same project. I have figured out how to get an summary for those who input exactly what project they are working on (Filter and Unique), but I would like to figure out how to have that same summary and add a breakdown of those hours that can be automatically allocated(ie if the staff puts in 10 hours, it is automatically broken down into Project 1 - 10%, Project 2-20%, Project 3-70% (ie, they just click on their name, and the number of hours that they do, and then excel automatically recognizes that and breaks it down).
I'm new to Mr. Excel - and would love some help figuring this out! Here's the sheet Book1.xlsx
I'm new to Mr. Excel - and would love some help figuring this out! Here's the sheet Book1.xlsx