Hi. I am trying to figure out how to sum various daily time entries for a week into seven categories. My guess is that I must first designated each entry with a code, say 1 to 7 for each time category. I am having trouble figuring out the formula to sum the numerous daily entires into one of each of the seven categories. In the end, the sum of the seven categories would equal the sum of the daily time entries for the entire work week. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Summing time entries
- Thread starter pfascia
- Start date
jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,830
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
I have a workbook that I use to keep track of numerous projects which are identified with a cost code and a sub component part.
There is a master worksheet which contains all the code/sub codes, this is used for a drop down on a setup sheet to define your own projects from the master list, this was done as this might in my case become used by more in the department and then I will look at updating the master list externally but that is way off at the moment.
There is a worksheet for each week where you can specify the code/sub and a description from a drop down list along with the time interval in 15 min slots.
The time for each code is summarised on that sheet, there is also an overall summary sheet which gives the amount of time spent on a project as the weeks go by, just in case the managers ask.
I am putting the finishing touches to this, but you quite welcome to what I have as is and customise it as.
If you send me a PM (personal message) with your email address I will send you a copy in the next few hours.
There is a master worksheet which contains all the code/sub codes, this is used for a drop down on a setup sheet to define your own projects from the master list, this was done as this might in my case become used by more in the department and then I will look at updating the master list externally but that is way off at the moment.
There is a worksheet for each week where you can specify the code/sub and a description from a drop down list along with the time interval in 15 min slots.
The time for each code is summarised on that sheet, there is also an overall summary sheet which gives the amount of time spent on a project as the weeks go by, just in case the managers ask.
I am putting the finishing touches to this, but you quite welcome to what I have as is and customise it as.
If you send me a PM (personal message) with your email address I will send you a copy in the next few hours.
Upvote
0
