A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calculating Employee hours for the current week



 
 
Thread Tools Display Modes
  #1  
Old August 19th, 2009, 01:05 AM posted to microsoft.public.excel.newusers
lunastu
external usenet poster
 
Posts: 3
Default 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  
Old August 19th, 2009, 08:35 AM posted to microsoft.public.excel.newusers
Alan McQuaid via OfficeKB.com
external usenet poster
 
Posts: 18
Default 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  
Old August 19th, 2009, 08:51 PM posted to microsoft.public.excel.newusers
lunastu
external usenet poster
 
Posts: 3
Default 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  
Old August 19th, 2009, 09:23 PM posted to microsoft.public.excel.newusers
lunastu
external usenet poster
 
Posts: 3
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.