ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I just want to add a W! (https://www.excelbanter.com/excel-programming/404321-i-just-want-add-w.html)

Outlook, eh?

I just want to add a W!
 
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=TimeOffCodesH</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-ignocolspan'Signatu</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'
</spanend of the day on the last day of the<span
style='mso-spacerun:yes' </spanpay period</td
<td colspan=3 style='mso-ignocolspan'</td
<td colspan=3 class=xl30 style='mso-ignocolspan'</td
<td colspan=5 style='mso-ignocolspan'</td
<td class=xl24 align=right x:num="0.25347222222222221"6:05 AM</td
<td class=xl26V</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-ignocolspan'</td
<td colspan=3 class=xl30 style='mso-ignocolspan'</td
<td colspan=5 style='mso-ignocolspan'</td
<td class=xl24 align=right x:num="0.25694444444444398"6:10 AM</td
<td class=xl26P</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-ignocolspan'</td
<td class=xl28</td
<td colspan=2 class=xl29 style='mso-ignocolspan'</td
<td class=xl30</td
<td class=xl28</td
<td colspan=4 class=xl25 style='mso-ignocolspan'</td
<td class=xl24 align=right x:num="0.26041666666666702"6:15 AM</td
<td class=xl27S</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-ignocolspan'</td
<td class=xl28</td
<td colspan=2 class=xl29 style='mso-ignocolspan'</td
<td class=xl30</td
<td class=xl28</td
<td colspan=4 class=xl25 style='mso-ignocolspan'</td
<td class=xl24 align=right x:num="0.26388888888888901"6:20 AM</td
<td class=xl27B</td
<td class=xl32 x:str=""

x:fmla="=IF(ISBLANK($L5),IF(ISNA(MATCH($E5,TimeOff Codes,0)),"",8),(($H5-$F5)+($L5-$J5))*24)"</td
</tr


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com