用EXCEL进行考勤及加班工时计算

1、姓姓名名日日期期上上班班时时间间（打打卡卡机机提提取取）下下班班时时间间（打打卡卡机机）上上班班时时间间（提提取取后后）下下班班时时间间（提提取取后后）考考勤勤( (上上班班) )2012-09-1108:06 15:048:0615:04迟到2012-09-1208:15 15:068:1515:06迟到2012-09-1308:07 15:058:0715:05迟到2012-09-1408:02 15:028:0215:02迟到2012-09-1508:02 15:048:0215:04迟到2012-09-16缺勤2012-09-1707:58 17:027:5817:02正常2012-0

2、9-1808:03 15:01 15:018:0315:01迟到2012-09-1915:0315:0315:03迟到2012-09-2008:08 15:048:0815:04迟到2012-09-2107:57 15:047:5715:04正常2012-09-2208:05 15:078:0515:07迟到2012-09-23缺勤2012-09-2408:49 15:078:4915:07迟到2012-09-2508:00 15:048:0015:04正常2012-09-2608:02 15:038:0215:03迟到2012-09-2708:17 15:018:1715:01迟到2012-

3、09-2808:01 15:028:0115:02迟到2012-09-29缺勤2012-09-30缺勤2012-10-01缺勤2012-10-02缺勤2012-10-03缺勤2012-10-04缺勤2012-10-05缺勤2012-10-06缺勤2012-10-07缺勤2012-10-08缺勤2012-10-0908:218:218:21迟到2012-10-1008:06 15:008:0615:00迟到缺勤考考勤勤( (下下班班) )考考勤勤（上上班班+ +下下班班）缺缺勤勤扣扣工工时时 统统计计迟迟到到时时间间（分分钟钟）迟迟到到扣扣工工时时（天天）早早退退时时间间（分分钟钟）早早退退扣扣

4、工工时时( (天天) )早退迟到+早退异常61161早退迟到+早退异常151141早退迟到+早退异常71151早退迟到+早退异常21181早退迟到+早退异常21161缺勤缺勤1异常正常正常正常早退迟到+早退异常31191早退迟到+早退异常42311171早退迟到+早退异常81161早退早退异常1161早退迟到+早退异常51131缺勤缺勤1异常早退迟到+早退异常490.51131早退早退异常1161早退迟到+早退异常21171早退迟到+早退异常171191早退迟到+早退异常11181缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常缺勤缺勤1异常早退迟到+早退异常215191早退迟到+早退异常61201缺勤缺勤1异常扣扣工工时时（总总）( (天天) )加加班班时时间间（分分钟钟）加加班班总总和和（天天）1.001.01.01.01.01.00.01.0