Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Employee hours for the current week
I think I figured this out.
The formula is: =INDEX(D10:BD10,1,WEEKNUM(NOW())+1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want a spreadsheet to track employee vacation/sick time hours | Charts and Charting in Excel | |||
employee schedule with hours | Excel Worksheet Functions | |||
Spread Sheet Employee Hours Issue | Excel Worksheet Functions | |||
Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
Calculating total work week hours | Excel Worksheet Functions |