ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
楼主: solongu

[讨论]此四位员工本月工资该拿多少

[复制链接]

TA的精华主题

TA的得分主题

发表于 2007-12-14 11:38 | 显示全部楼层
<p>又学习了。感谢楼主和版主</p>[em04]

TA的精华主题

TA的得分主题

发表于 2008-1-2 13:25 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>2003-gaoxj</i>在2007-6-29 12:50:55的发言:</b><br/>为什么丙没有延长工时工资?</div><p>还劳版主解释一下。谢谢!</p>

TA的精华主题

TA的得分主题

发表于 2008-2-20 11:18 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
<p>关于“为什么丙没有延长工时工资?“,个人认为是,公司已经给了丙一天的补休,如果按这样算,丙1月份的工作时间就是15*12-1*12=180-12=168,&nbsp;而该企业实行标准工时的制度工作日为22天,22*8=176,丙没有延长工时工资。</p><p>想问斑竹或搂主,因为进入2008年,分了两个概念,分别是20.83的工作时间和21.75的计薪时间。</p><p>同样的题目,到2008年应该怎样算呢?</p><p></p>

TA的精华主题

TA的得分主题

发表于 2008-2-20 17:46 | 显示全部楼层

回复:(taylor_penny)关于“为什么丙没有延长工时工...

<p>感谢您的提醒。我也重新学了一遍。呵呵。</p><p>写此帖的时候依据的是《关于职工全年月平均工作时间和工资折算问题的通知》(劳社部发〔2000〕8号),这个文件已经废止.<br/>08年1月劳动保障部发了《关于职工全年月平均工作时间和工资折算问题的通知》明确了 "小时工资的折算"概念,<br/>2000年的文件中(原文件)在计算小时工资的时候是将10个节日减除后再计算月计薪天数的,现在新的&lt;通知&gt;是将这11天节日不剔除的情况下计算"月计薪天数"的.新的办法更清晰明确了计薪日概念.</p><p><table cellspacing="0" cellpadding="0" width="520" border="0" style="WIDTH: 390pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col><col width="79" style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2528;"></col><col width="158" style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5056;"></col><col width="143" style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 4576;"></col><col width="68" style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2176;"></col></colgroup><tbody><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl22" width="72" height="47" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 35.25pt; BACKGROUND-COLOR: transparent;"><strong><font face="宋体">概念</font></strong></td><td class="xl22" width="79" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><strong><font face="宋体">适用于</font></strong></td><td class="xl22" width="158" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 119pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><strong><font face="宋体">计算公式</font></strong></td><td class="xl22" width="143" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 107pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><strong><font face="宋体">文件出处</font></strong></td><td class="xl22" width="68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><strong><font face="宋体">备注</font></strong></td></tr><tr height="77" style="HEIGHT: 57.75pt; mso-height-source: userset;"><td class="xl23" width="72" height="77" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 57.75pt; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" size="2">21.75天</font></strong></td><td class="xl24" width="79" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">日工资、小时工资的折算</font></td><td class="xl24" width="158" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 119pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体">(</font><font class="font6" face="Times New Roman">365</font><font class="font5" face="宋体">天</font><font class="font6" face="Times New Roman">-104</font><font class="font5" face="宋体">天)÷</font><font class="font6" face="Times New Roman">12</font><font class="font5" face="宋体">月=</font><font class="font6" face="Times New Roman">21.75</font><font class="font5" face="宋体">天</font></font></td><td class="xl24" width="143" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 107pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">《关于职工全年月平均工作时间和工资折算问题的通知》(劳社部发[2008]3号 )</font></td><td class="xl24" width="68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">现规定</font></td></tr><tr height="77" style="HEIGHT: 57.75pt; mso-height-source: userset;"><td class="xl23" width="72" height="77" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 57.75pt; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" size="2">20.83天</font></strong></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><form name="modactions" method="post"><font color="#333333"><font size="2"><font face="宋体">制度工作时间</font><font class="font7"><span style="mso-spacerun: yes;">&nbsp;</span></font><font face="宋体">
                                                                        </font></font></font></form></td><td class="xl24" width="158" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 119pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">365天减去11个法定节日(十一\春假各3天,五一\元旦\端午\清明\中秋各1天),再减去104个公休日 除以12个月=20.83天</font></td><td class="xl24" width="143" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 107pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">《关于职工全年月平均工作时间和工资折算问题的通知》(劳社部发[2008]3号 )</font></td><td class="xl24" width="68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">现规定</font></td></tr><tr height="77" style="HEIGHT: 57.75pt; mso-height-source: userset;"><td class="xl26" width="72" height="77" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 57.75pt; BACKGROUND-COLOR: transparent;"><s><strong><font face="宋体" size="2">20.92天</font></strong></s></td><td class="xl24" width="79" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">职工的日工资和小时工资按此进行折算</font></td><td class="xl24" width="158" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 119pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><div style="OVERFLOW-X: hidden; WORD-WRAP: break-word;"><font face="宋体" size="2">365天减去10个法定节日(五一\十一\春假各3天,元旦1天),再减去104个公休日 除以12个月=20.92天</font></div></td><td class="xl24" width="143" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 107pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">《关于职工全年月平均工作时间和工资折算问题的通知》(劳社部发〔2000〕8号)</font></td><td class="xl27" width="68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><s><font face="宋体" size="2">已经废止</font></s></td></tr></tbody></table></p><p>以计算此案例中甲职工的延长工时为例:</p><p>原案例中甲职工的延长工时 工资为:<br/>(12*15-22*8)*(2000/20.92/8)*1.5=71.7元<br/>现在则为:<br/>(12*15-22*8)*(2000/21.75/8)*1.5=68.94元<br/>比原来拿到手中的钱稍微少了。</p>

TA的精华主题

TA的得分主题

发表于 2008-2-20 17:54 | 显示全部楼层
<p>哦,明白。那如果企业是按文件执行的,每月工作20.83个工作日的话,那以甲为例就是</p><p>(12*15-20.83*8)*(2000/21.75/8)*1.5=230.34元吗?</p><p><br/></p><p></p>

TA的精华主题

TA的得分主题

发表于 2008-2-20 18:13 | 显示全部楼层
<p>&nbsp;</p><img src="attachments/dvbbs/2008-2/200822018152415290.png" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><br/>案例中 要计算甲职工当月这个周期,延长的工时是多少,所以用22天。。如果要是2月份就是18天了。
[此贴子已经被作者于2008-2-20 18:18:39编辑过]
kjMpxJlY.png

TA的精华主题

TA的得分主题

发表于 2008-2-20 18:26 | 显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件       ★免费下载 ★       ★ 使用帮助
<p>哦,这下就完全明白了。原来是因为实际工作天的关系。</p><p>我所在的公司是一刀切,每月都是按21.75算的</p><p>所以不用每月都改实际工作天数</p><p>各有利弊吧!大家也学习学习!</p><p>谢谢!</p>

TA的精华主题

TA的得分主题

发表于 2008-2-25 01:13 | 显示全部楼层
<p>由于采用了21.75的算法时,法定假期是没有被减去的,故,基础工资里已经包含了11天假期的日工资了。即使法定假期不上班,也不用另外支付带薪假期的工资了。</p><p>以下是2008年的算法,同时,我用2007年的算法做了对比,不知道我的思路是否正确,请高手点评。</p><p><table cellspacing="0" cellpadding="0" width="830" border="0" style="WIDTH: 624pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="6" width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="271" style="WIDTH: 203pt; mso-width-source: userset; mso-width-alt: 8672;"></col><col width="191" style="WIDTH: 143pt; mso-width-source: userset; mso-width-alt: 6112;"></col><col width="122" style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 3904;"></col></colgroup><tbody><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl24" width="41" height="173" rowspan="5" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 129.75pt; BACKGROUND-COLOR: transparent;"><strong><font face="宋体" size="2">2008</font></strong></td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">姓名</font></td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">正常出勤</font></td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">元旦出勤</font></td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">实际出勤</font></td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">基础工资</font></td><td class="xl25" width="271" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 203pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">平时的加班工资</font></td><td class="xl25" width="191" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 143pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">法定假期的加班工资</font></td><td class="xl25" width="122" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 92pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">应发工资</font></td></tr><tr height="21" style="HEIGHT: 15.75pt; mso-height-source: userset;"><td class="xl25" height="21" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">甲</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">15</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">休息</font><div></div></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">15</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2000</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体">(12*<font class="font6" color="#ff0000"><strong>15</strong></font><font class="font7">-22*8)*(2000/21.75/8)*1.5=68.97</font></font></font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"> </font></td><td class="xl28" width="122" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 92pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2068.97 </font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl25" height="27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">乙</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">16</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">上班</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">17</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2000</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体">(12*<font class="font6" color="#ff0000"><strong>15</strong></font><font class="font7">-22*8)*(2000/21.75/8)*1.5=68.97</font></font></font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">(2000/21.75/8)*12*3=413.79</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2482.76</font></td></tr><tr height="51" style="HEIGHT: 38.25pt; mso-height-source: userset;"><td class="xl25" height="51" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">丙</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">15</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">加班</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">16</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2000</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体">(12*<font class="font6" color="#ff0000"><strong>15</strong></font><font class="font7">-22*8)*(2000/21.75/8)*1.5=68.97</font></font></font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">(2000/21.75/8)*12*3=413.79</font></td><td class="xl26" width="122" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 92pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2482.76 另外还要减去补休的那天(2000/21.75)</font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl25" height="27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">丁</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">15</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">加班</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">16</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2000</font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"><font face="宋体">(12*<font class="font6" color="#ff0000"><strong>15</strong></font><font class="font7">-22*8)*(2000/21.75/8)*1.5=68.97</font></font></font></td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">(2000/21.75/8)*12*3=413.79</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">2482.76</font></td></tr></tbody></table></p>
[此贴子已经被作者于2008-2-25 2:34:01编辑过]

TA的精华主题

TA的得分主题

发表于 2008-2-25 01:27 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
<p>可以用<font color="#1111ee"><strong>版主xoif</strong></font>的2007年算法作对比分析。</p><p><table cellspacing="0" cellpadding="0" width="863" border="0" style="WIDTH: 649pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="40" style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1280;"></col><col width="42" style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1344;"></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="49" style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1568;"></col><col width="302" style="WIDTH: 227pt; mso-width-source: userset; mso-width-alt: 9664;"></col><col width="239" style="WIDTH: 179pt; mso-width-source: userset; mso-width-alt: 7648;"></col><col width="68" style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2176;"></col></colgroup><tbody><tr height="32" style="HEIGHT: 24pt;"><td class="xl27" width="41" height="96" rowspan="5" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 31pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 72pt; BACKGROUND-COLOR: transparent;"><strong><font size="2">2007</font></strong></td><td class="xl24" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">姓名</font></td><td class="xl25" width="40" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 30pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">应出勤</font></td><td class="xl25" width="42" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 32pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">元旦出勤</font></td><td class="xl25" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">实际出勤</font></td><td class="xl25" width="49" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 37pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">基础</font></td><td class="xl25" width="302" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 227pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">延长工时</font></td><td class="xl25" width="239" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 179pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">加班工资</font></td><td class="xl25" width="68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">应发工资</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl26" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">甲</font><div></div></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">15</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">休息</font><div></div></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">15</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">(12*15-22*8)*(2000/20.92/8)*1.5=71.7</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"> </font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2071.7</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl26" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">乙</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">16</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">上班</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">17</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">(12*15-22*8)*(2000/20.92/8)*1.5=71.7</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">(2000/20.92/8)*12*3=430.2</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2501.9</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl26" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">丙</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">15</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">加班</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">16</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">(2000/20.92/8)*12*3=430.2</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2"> </font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2430.2</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl26" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">丁</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">15</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">加班</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">16</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2000</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">(12*15-22*8)*(2000/20.92/8)*1.5=71.7</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">(2000/20.92/8)*12*3=430.2</font></td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font size="2">2501.9</font></td></tr></tbody></table></p>

TA的精华主题

TA的得分主题

发表于 2008-8-27 16:35 | 显示全部楼层

[求助]综合工时制相关规定

<p>关于综合工时,一天不能连续工作11小时~!</p>
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-12-26 03:12 , Processed in 0.054371 second(s), 9 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表