Forum Discussion
Project schedule
Is it possible for you to post not an image but the actual spreadsheet you created as the basis for that image?
It would help us help you if you did it that way. Otherwise, beyond just telling you, 'Yes, it's possible" if you want some actual help in creating the formula...please, a spreadsheet.
And for the sake of clarification: are you saying you'd be putting in 44 instead of the 48 that appears there now? And would it be fair or safe to assume that you could also be asking "if any of the other numbers change as well, what would need to be done in order for the bottom left cell to read 1750?" Or is it only the Sales employee who might vary from the standard 48?
In other words, is it that the 1750 needs to be held as a constant goal to be achieved, with the other hours somewhat malleable? And are there limits to how many can be malleable, or how much malleability is allowed?
Can you tell us more about the bigger picture here? I used to be Director of HR and Payroll systems for a major corporation. I don't recall ever being asked to create a sheet like this. Ever. It almost seems like a case of the tail wagging the dog. Why aren't we just totaling actual hours?
mathetes I attached the file. In regards to the next question: I have a calendar where I plan out the travel by week and then total the hours by month, so it would be 44 hours for that week on Sales which would change the redistribution of hours. Currently the monthly hour is 48 for Sales, but now with the travel it might change the number to 54: 44 for the travel and then 10 for the redistributed number amongst the categories. You are correct in that I’m asking if travel occurred in other months at various number of hours (those would inputted first) and what is the distribution of the remaining hours for that month/year. It doesn’t need to be exactly 1750, could go as high as 1800 but no lower than 1750.
I can’t disclose too much on the bigger picture but what I can say is that I do this for multiple people across multiple fiscal years so I’m just looking for a faster way.
What I Really want is to say something like this:
I just want to plug in travel dates, determine how many hours that would consist of (excluding holidays/weekends/other pto), total up the total travel hours by month/category, and it would recalculate the total number is hours for each category/month and equal close 1750.