excel员工考勤表统计迟到

员工考勤表统计—迟到,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序号,姓名,月份：7月份,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,出勤,迟到,请假,备注

1,员工1,√,√,☆,√,√,√,√,√,√,√,√,√,√,☆,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,27,3,0,

2,员工2,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,○,√,○,√,√,☆,√,√,√,√,√,√,√,√,27,1,2,

3,员工3,○,√,√,√,√,√,√,√,√,√,√,√,○,√,√,○,√,√,√,√,√,√,√,√,√,√,√,√,√,√,27,0,2,

4,员工4,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,○,√,√,☆,√,√,√,√,√,√,28,1,1,

5,员工5,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,29,1,0,

6,员工6,○,√,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,√,28,1,0,

7,员工7,√,√,√,√,√,○,√,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,☆,26,3,1,

8,员工8,√,○,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,☆,27,2,0,

9,员工9,√,√,√,√,√,○,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,28,1,1,

10,员工10,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,29,1,0,

11,员工11,√,○,☆,√,√,√,√,○,√,√,☆,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,25,3,1,

12,员工12,√,√,√,√,√,√,√,√,√,○,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,28,1,1,

13,员工13,√,√,√,√,√,√,√,√,√,√,√,√,○,√,√,√,√,√,√,√,√,√,√,√,√,○,☆,√,√,√,27,1,2,

14,员工14,√,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,○,√,√,√,√,√,√,√,√,√,√,√,√,√,28,1,1,

15,员工15,○,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,28,1,0,

16,员工16,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,28,2,0,

17,员工17,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,28,2,0,

18,员工18,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,28,2,0,

19,员工19,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,28,2,0,

20,员工20,√,√,√,√,√,√,√,√,√,☆,√,√,√,√,√,√,