考勤表-白班夜班分开计算.xlsx

选择年月2019年10月考 勤 表NO姓名班别岗位区分123456789101112131415161718192021222324周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四1杨庆华A岗位1正常√√√√√√√√√√√√√√√√√√√√√√√√加班123456789101112123456789101112夜班夜夜夜餐费5555555555555555555555552张福俊A岗位2正常√√√√√√√√√√√√√√√√√√√√√√√√加班123456789101112123456789101112夜班夜夜夜餐费5555555555555555555555553王勇新B岗位3正常√√√√√√√√√√√√√√√√√√√√√√√√加班123456789101112123456789101112夜班夜夜夜餐费5555555555555555555555554罗斌B岗位4正常√√√√√√√√√√√√√√√√√√√√√√√√加班123456789101112123456789101112夜班夜夜夜餐费5555555555555555555555555罗斌B岗位5正常√√√√√√√√√√√√√√√√√√√√√√√√加班123456789101112123456789101112夜班夜夜夜餐费5555555555555555555555556罗斌B岗位6正常√√√√√√√√√√√√√√√√√√√√√√√√加班123456789101112123456789101112夜班夜夜夜考 勤 表25262728293031应出勤天数平时
天数(√)计薪 休假(J)缺勤 天数平日
加班(P)特勤
加班(T)法定
加班(F)夜班
天数(Y)餐费
金额用餐费用实际餐补备注周五周六周日周一周二周三周四√√√√√√√32310118400015015012345675555555√√√√√√√33310218400015015012345675555555√√√√√√√34310318400015015012345675555555√√√√√√√35310418400015015012345675555555√√√√√√√36310518400015015012345675555555√√√√√√√3731061840001501501234567