[留学新加坡出勤率的重要性]据留学360介绍,新加坡政府对于留学生的素质要求越来越高,也将提高新加坡院校的整体规模与质量,为此,您必须注意您在留学期间的出勤率,否则将面临受到移民机关的警告甚至取消签证...+阅读
A列放姓名,B列放上班时间,C列放下班时间,D、E列分别为上、下班情况
首先在第二行插入参考行,上下班时间填好~
然后在D3单元格填入公式
=IF((HOUR(B3)-HOUR($B$2))*60+MINUTE(B3)-MINUTE($B$2)<=0,"正常","迟到"&TRUNC(((HOUR(B3)-HOUR($B$2))*60+MINUTE(B3)-MINUTE($B$2))/60)&"小时"&(HOUR(B3)-HOUR($B$2))*60+MINUTE(B3)-MINUTE($B$2)-TRUNC(((HOUR(B3)-HOUR($B$2))*60+MINUTE(B3)-MINUTE($B$2))/60)*60&"分钟")
E3单元格填入公式
=IF((HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2)<0,"早退"&(TRUNC(((HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2))/60))*(-1)&"小时"&((HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2)-TRUNC(((HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2))/60)*60)*(-1)&"分钟",IF((HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2)<=30,"正常","加班"&TRUNC(((HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2))/60)&"小时"&(HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2)-TRUNC(((HOUR(C3)-HOUR($C$2))*60+MINUTE(C3)-MINUTE($C$2))/60)*60&"分钟"))
下拉即可~
以下为关联文档:
约在晚上下班如何How about early evening, just after work?晚上一下班的时候如何?A: I'm afraid I he to go. I've got an early start tomorrow.A: 我恐怕得走了。我明天早晨得早起。B...
上课出勤率For this part, you are allowed 30 minutes to write a position on the topic: Attend Your Classes Regularly.You should write at least 120 words following the outl...
2月份的出勤天数该怎么算每个月的出勤率计算方法相同: 1、实际出勤天数 实际出勤天数=应出勤天数-缺勤天数 2、应出勤天数 应出勤天数=月历天数-周六、日天数-法定假天数 3、缺勤天数 缺勤天数=事假...