If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating Employee hours for the current week
Hello,
I am new to excel and have been assigned the task of creating a file that breaks down the amount of time each of our employees spends on different projects. Most importantly I want to create a rollup sheet that shows the total number of hours all the employees have spent on the different projects (there are 6) for the current week. Is there any way for excel to figure out the current week then add together the hours all the employees worked on these 6 projects? Thanks in advance. |
#2
|
|||
|
|||
Calculating Employee hours for the current week
Hi,
Take a look at the templates available from Microsoft at http://office.microsoft.com/en-us/te...aspx?av=ZXL000 These should be able to start you off Alan -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
Calculating Employee hours for the current week
On Aug 19, 12:35*am, "Alan McQuaid via OfficeKB.com" u23024@uwe
wrote: Hi, Take a look at the templates available from Microsoft athttp://office.microsoft.com/en-us/templates/CT101172771033.aspx?av=ZX... These should be able to start you off Alan -- Message posted viahttp://www.officekb.com Thanks Alan, Those were all nice but I could not find one that had a good formula for dynamically collecting info for the current week only. I have a total of 7 projects and 7 employees. What i want to do is track the total number of hours spent by all the employees on each one of the individual projects for the current week (1-52). Any ideas how I can tell excel which week is the current one, then get the info from each employee for that week only? Thanks in advance! Ben |
#4
|
|||
|
|||
Calculating Employee hours for the current week
I think I figured this out.
The formula is: =INDEX(D10:BD10,1,WEEKNUM(NOW())+1) |
Thread Tools | |
Display Modes | |
|
|