O
Outlook, eh?
So here is some code that my predecessor wrote within a timesheet. This
section is a drop-down box with the TimeOffcodes H,V,P,S,B. I just want to
add a W!! Please help. THANKS!
<td class=xl26 width=0><a name=TimeOffCodes>H</a></td>
<td class=xl31 width=0></td>
</tr>
<tr height=42 style='mso-height-source:userset;height:31.65pt'>
<td height=42 class=xl33 colspan=3
style='height:31.65pt;mso-ignore:colspan'>Signature:</td>
<td colspan=4 class=xl44> </td>
<td colspan=7 rowspan=2 class=xl59 width=306 style='width:229pt'>Turn in to
your supervisor by the<span style='mso-spacerun:yes'>
</span>end of the day on the last day of the<span
style='mso-spacerun:yes'> </span>pay period</td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl30 style='mso-ignore:colspan'></td>
<td colspan=5 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.25347222222222221">6:05 AM</td>
<td class=xl26>V</td>
<td class=xl31></td>
</tr>
<tr height=42 style='mso-height-source:userset;height:31.65pt'>
<td colspan=7 height=42 class=xl45 style='height:31.65pt'> </td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl30 style='mso-ignore:colspan'></td>
<td colspan=5 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.25694444444444398">6:10 AM</td>
<td class=xl26>P</td>
<td class=xl31></td>
</tr>
<tr class=xl25 height=42 style='mso-height-source:userset;height:31.65pt'>
<td colspan=2 height=42 class=xl41 style='border-right:.5pt solid black;
height:31.65pt'>Date</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Day</td>
<td class=xl36 style='border-top:none'>Code</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black'>Start</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Lunch</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Return</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>End</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Hours</td>
<td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl28></td>
<td colspan=2 class=xl29 style='mso-ignore:colspan'></td>
<td class=xl30></td>
<td class=xl28></td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.26041666666666702">6:15 AM</td>
<td class=xl27>S</td>
<td class=xl32></td>
</tr>
<tr class=xl25 height=42 style='mso-height-source:userset;height:31.65pt'>
<td colspan=2 height=42 class=xl48 style='height:31.65pt'> </td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Monday</td>
<td class=xl37 style='border-top:none;border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl46 style='border-left:none' x:str=""
x:fmla="=IF(NOT(ISNUMBER($AC5)),"",IF($AC5-(TRUNC($AC5))<0.35,FLOOR($AC5,0.1),$AC5))"> </td>
<td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl28></td>
<td colspan=2 class=xl29 style='mso-ignore:colspan'></td>
<td class=xl30></td>
<td class=xl28></td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.26388888888888901">6:20 AM</td>
<td class=xl27>B</td>
<td class=xl32 x:str=""
x:fmla="=IF(ISBLANK($L5),IF(ISNA(MATCH($E5,TimeOffCodes,0)),"",8),(($H5-$F5)+($L5-$J5))*24)"></td>
</tr>
section is a drop-down box with the TimeOffcodes H,V,P,S,B. I just want to
add a W!! Please help. THANKS!
<td class=xl26 width=0><a name=TimeOffCodes>H</a></td>
<td class=xl31 width=0></td>
</tr>
<tr height=42 style='mso-height-source:userset;height:31.65pt'>
<td height=42 class=xl33 colspan=3
style='height:31.65pt;mso-ignore:colspan'>Signature:</td>
<td colspan=4 class=xl44> </td>
<td colspan=7 rowspan=2 class=xl59 width=306 style='width:229pt'>Turn in to
your supervisor by the<span style='mso-spacerun:yes'>
</span>end of the day on the last day of the<span
style='mso-spacerun:yes'> </span>pay period</td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl30 style='mso-ignore:colspan'></td>
<td colspan=5 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.25347222222222221">6:05 AM</td>
<td class=xl26>V</td>
<td class=xl31></td>
</tr>
<tr height=42 style='mso-height-source:userset;height:31.65pt'>
<td colspan=7 height=42 class=xl45 style='height:31.65pt'> </td>
<td colspan=3 style='mso-ignore:colspan'></td>
<td colspan=3 class=xl30 style='mso-ignore:colspan'></td>
<td colspan=5 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.25694444444444398">6:10 AM</td>
<td class=xl26>P</td>
<td class=xl31></td>
</tr>
<tr class=xl25 height=42 style='mso-height-source:userset;height:31.65pt'>
<td colspan=2 height=42 class=xl41 style='border-right:.5pt solid black;
height:31.65pt'>Date</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Day</td>
<td class=xl36 style='border-top:none'>Code</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black'>Start</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Lunch</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Return</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>End</td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Hours</td>
<td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl28></td>
<td colspan=2 class=xl29 style='mso-ignore:colspan'></td>
<td class=xl30></td>
<td class=xl28></td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.26041666666666702">6:15 AM</td>
<td class=xl27>S</td>
<td class=xl32></td>
</tr>
<tr class=xl25 height=42 style='mso-height-source:userset;height:31.65pt'>
<td colspan=2 height=42 class=xl48 style='height:31.65pt'> </td>
<td colspan=2 class=xl41 style='border-right:.5pt solid black;border-left:
none'>Monday</td>
<td class=xl37 style='border-top:none;border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl47 style='border-left:none'> </td>
<td colspan=2 class=xl46 style='border-left:none' x:str=""
x:fmla="=IF(NOT(ISNUMBER($AC5)),"",IF($AC5-(TRUNC($AC5))<0.35,FLOOR($AC5,0.1),$AC5))"> </td>
<td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl28></td>
<td colspan=2 class=xl29 style='mso-ignore:colspan'></td>
<td class=xl30></td>
<td class=xl28></td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
<td class=xl24 align=right x:num="0.26388888888888901">6:20 AM</td>
<td class=xl27>B</td>
<td class=xl32 x:str=""
x:fmla="=IF(ISBLANK($L5),IF(ISNA(MATCH($E5,TimeOffCodes,0)),"",8),(($H5-$F5)+($L5-$J5))*24)"></td>
</tr>