Need More Help....Cont-

G

Guest

Guest
Here is the lookup table I am using.
column A Column B Column C
DUTY CODES SHRED CODES EXPLANATION
11 Direct Labor REG
411 Over Time OT
611 Compensate CT
12 Direct TDY
26 30 Shop Clean-up SHPC
26 66 Tool Control TCIS
27 1 Training TRNG
29 Union Activities UNIN
31 Annual Leave AL
32 Sick Leave SL
33 44 Holiday HOL
38 Compensatory Leave CTL
What I explained earlier, I would like for a blank to appear whenever a number that is not on the lookup table is entered in column f6, but I got a #N/a instead.
Below is a small sample of my excel sheet that I use for time.

col a col b col c col d
date code hrs type code

______________________________
M 3-1-02 | 27 | 2.5 | TRNG
M 3-1-02 | 11 | 2.5 | (REG)Work is Blank
M 3-1-02 | 31 | 3 | AL
T 3-2-02 | 11 | 8 |
W 3-3-02 | 11 | 2 |
w 3-3-02 | 27 | 2 |Inserted extra line
W 3-3-02 | 32 | 4 | SL

NOW For Part 2!!!

I also need a formula to total each day's hours, not to exceed 8 hrs, unless OT code is in col B, What the problem is, I have a summary sheet by day which shows only if I was off for Sick Leave or Annual Leave. Each line is used for a single day. I do not know how to write a formula to look at more than one line if that date goes beyond one line.
If a line is inserted in the above form my AL will move one day later or not appear at all.
# Pay Period...... M T W T F / M T W T F
06 Mar 24 Apr 06.. 3 4
07 Apr 07 Apr 20..
08 Apr 21 May 04..
09 May 05 May 18..
10 May 19 Jun 01..

HELP,

Thanks
Walter

If you want, I will sent you part of the woorkbook to anyone who can give me more pointers on this.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top