LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Calculating hours per week spent by a resource

Dear Excel-lent users,

Could you please help me with the following challenge ?

In Row 2 (B2:AC2) I have the numbers of the week starting from 1 till 28
In Column 1 (A3:A24) I have the names of the resources

Per week I fill in the hours per resources for different tasks, so one name
will occur multiple times in Column 1. The hours are filled in in the Area
B3:AC24.

Now I want to know per week how many hours 1 resource is booked.

Could you please help me with a formula to calculate this?

Thank you very much !!

Jaydubs !
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Employee hours for the current week lunastu New Users to Excel 3 August 19th 09 09:23 PM
how to calculate productivity over hours spent Balaji Excel Worksheet Functions 4 August 13th 09 12:33 PM
Calculating hours spent per team The Fool on the Hill Excel Discussion (Misc queries) 1 December 29th 08 02:37 PM
summing up hours spent on jobs kayti57 Excel Discussion (Misc queries) 2 November 29th 06 05:51 AM
Calculating total work week hours Harley mom Excel Worksheet Functions 2 December 20th 05 05:41 PM


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"