PC Review


Reply
Thread Tools Rate Thread

Assign a project name to weekly hours/pay

 
 
Phoenix Bass
Guest
Posts: n/a
 
      16th Jul 2008
I want to input one employee's hours/pay for each week of the year. Then in
the next column associate a project name etc. for the whole year.
Then at the top page(maybe frozen) I want each project name to pull only the
data with its associated name (next to it) for a yearly total.
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      16th Jul 2008
=SUMIF(project_col,project_name,pay_col)

--
__________________________________
HTH

Bob

"Phoenix Bass" <Phoenix (E-Mail Removed)> wrote in message
news:B282D21E-D153-4848-8526-(E-Mail Removed)...
>I want to input one employee's hours/pay for each week of the year. Then
>in
> the next column associate a project name etc. for the whole year.
> Then at the top page(maybe frozen) I want each project name to pull only
> the
> data with its associated name (next to it) for a yearly total.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif and translate annual hours into weekly quarter hours se7098 Microsoft Excel Worksheet Functions 21 11th Oct 2008 01:37 AM
Hours Weekly To Hours Monthly Problem =?Utf-8?B?UmF5IFMu?= Microsoft Access 8 9th Oct 2007 02:14 PM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis =?Utf-8?B?R3JhaGFt?= Microsoft Excel Misc 2 28th Jan 2007 08:40 PM
Weekly Hours =?Utf-8?B?SmF5YmlyZA==?= Microsoft Access Forms 6 3rd Apr 2006 12:06 AM
Hourly weekly work hours Rudy Microsoft Access Queries 1 6th Jan 2004 07:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:51 PM.