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.
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.