员工考勤表全自动.xlsx

员工考勤表全自动日 期：2023年2月个人
查询工号姓名姓名出勤请假旷工早退迟到（次）全勤出勤统计应出勤：23天AJ11金山1部门1220.50.52否工号姓名部门时间 日期周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日1234567891011121314151617181920212223242526AJ11金山1部门1上午√√◉√√√√√√√√√√√√√√√下午√√×√√√√√√√√√√√√√√√AJ12金山2部门2上午√√√√√√√√√√√√√√√√√√下午√√√√√√√√√√√√√√√√√√AJ13金山3部门3上午√√√√√√√√√√√√√√√√√√下午√√√√√√√√√√√√√√√√√√AJ14金山4部门4上午√√√√√√√√√√√√★√√√√√下午√√√√√√√√√√√√★√√√√√AJ15金山5部门5上午★√√√√√√√√√√√√√√√√√下午★√√√√√√√√√√√√√√√√√AJ16金山6部门6上午◉√√√√√√√√√√√√√√√√√下午√√√√√√√√√√√√√√√√√√AJ17金山7部门7上午√√√√√√√√√√√√√√√√√√下午◉√√√√√√√√√√√√√√√√√AJ18金山8部门8上午√√√√√√√√√√√√√√√√√√下午√√√√√√√√√√√√√√√√√√AJ19金山9部门9上午√√√√√√√√√√√√√√√√√√下午√√√√√√√√√√√√√√√√√√员工考勤表全自动人数出勤天数缺勤天数出勤率9200.56.597%周一周二周三周四周五出勤
√请假
★旷工
×早退迟到
◉√应出勤232728123◉开始日期3月1日√√√◉★220.50.52×结束日期3月31日√√√√√★假期√√√√√23000√√√√√√√√√√23000√√√√√√√√√√22100√√√√√×√√√√211.50.50★√√√√★√√√√22101★√√√√★√√√√22101★√√√√★√√√√22.50.500√√√√√√√√√√23000√√√√√00000000