Schedule

  • Thread starter Thread starter Matt Kubinski
  • Start date Start date
M

Matt Kubinski

I have built a year schedule into excel that we have used for sometime. The
way the schedule looks is in each cell is the initals of the person working
(ie MDK). They now would like the schedule to autocalculate the hours
worked. We do not need to worry about breaks or anything like that. Most
everyone works 8 hours a day. Is there a way to assign a number for hours
worked to the initals so we can have a two-week summary?
 
You can use a lookup table. Say in a second sheet (Sheet2):

A B
1 MDK 8
2 JEM 8
3 ABC 4
4 ...

Then in Sheet1

=COUNTIF(B2:N2,"MDK")* VLOOKUP("MDK",Sheet2!A:B,2, FALSE)
 
Hi Matt

Try this. Add the names to Column A of any sheet. Now in Column B add
their associated hours. Now select the data in both of these Columns and
go to Insert>Name>Create. Ensure ONLY left "Left Column" is ticked and
click Ok.

Now in any cell use

=MDK*14 or =MDK*10 etc

or, if the if you wish to reference the initials from another cell, use

=INDIRECT(A1)*14 etc

Where A1 houses somebodies initial.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top