EXCEL-万能的排班表(考勤版)

年工作人员值班表112345678910111213141516171819202122232425262728293031##############################################################1邹　勇早晚中早晚中早晚中早晚中早晚中早晚中早2王　凌早晚中早晚中早晚中早晚中早晚中早晚中早3王敢登中早晚中早晚中早晚中早晚中早晚中早晚中4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚中5苏　广晚中早晚中早晚中早晚中早晚中早晚中早晚6陈文颂晚中早晚中早晚中早晚中早晚中早晚中早晚7张　杰中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚9许　可中早晚中早晚中早晚中早晚中早晚中早晚10左智峰中早晚中早晚中早晚中早晚中早晚中早晚2019姓名一月序号年工作人员值班表2123456789101112131415161718192021222324252627周五周六周日周一周二周三周四周五周六####################################1邹　勇晚中早晚中早晚中早晚中早晚中早晚2王　凌晚中早晚中早晚中早晚中早晚中早晚3王敢登早晚中早晚中早晚中早晚中早晚中早晚4肖　虎早晚中早晚中早晚中早晚中早晚中早晚5苏　广中早晚中早晚中早晚中早晚中早晚6陈文颂中早晚中早晚中早晚中早晚中早晚7张　杰中早晚中早晚中早晚中早晚中早晚中早8郑小鹏中早晚中早晚中早晚中早晚中早晚中早9许　可中早晚中早晚中早晚中早晚中早晚中10左智峰中早晚中早晚中早晚中早晚中早晚中2019二月序号姓名28##中中晚晚早早二月年工作人员值班表312345678910111213141516171819202122232425262728293031##############################################################1邹　勇中早晚中早晚中早晚中早晚中早晚中早晚中2王　凌中早晚中早晚中早晚中早晚中早晚中早晚中3王敢登中早晚中早晚中早晚中早晚中早晚中早晚4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚5苏　广早晚中早晚中早晚中早晚中早晚中早晚中早6陈文颂早晚中早晚中早晚中早晚中早晚中早晚中早7张　杰中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚9许　可晚中早晚中早晚中早晚中早晚中早晚中早晚10左智峰晚中早晚中早晚中早晚中早晚中早晚中早晚2019三月序号姓名年工作人员值班表4123456789101112131415161718192021222324252627282930############################################################1邹　勇早晚中早晚中早晚中早晚中早晚中早晚中2王　凌早晚中早晚中早晚中早晚中早晚中早晚中3王敢登中早晚中早晚中早晚中早晚中早晚中早晚4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚5苏　广晚中早晚中早晚中早晚中早晚中早晚中早6陈文颂晚中早晚中早晚中早晚中早晚中早晚中早7张　杰中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚9许　可中早晚中早晚中早晚中早晚中早晚中早晚10左智峰中早晚中早晚中早晚中早晚中早晚中早晚2019四月序号姓名年工作人员值班表512345678910111213141516171819202122232425262728293031##############################################################1邹　勇早晚中早晚中早晚中早晚中早晚中早晚中早2王　凌早晚中早晚中早晚中早晚中早晚中早晚中早3王敢登中早晚中早晚中早晚中早晚中早晚中早晚中4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚中5苏　广晚中早晚中早晚中早晚中早晚中早晚中早晚6陈文颂晚中早晚中早晚中早晚中早晚中早晚中早晚7张　杰中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚9许　可中早晚中早晚中早晚中早晚中早晚中早晚10左智峰中早晚中早晚中早晚中早晚中早晚中早晚2019五月序号姓名年工作人员值班表6123456789101112131415161718192021222324252627282930############################################################1邹　勇晚中早晚中早晚中早晚中早晚中早晚中早2王　凌晚中早晚中早晚中早晚中早晚中早晚中早3王敢登早晚中早晚中早晚中早晚中早晚中早晚中4肖　虎早晚中早晚中早晚中早晚中早晚中早晚中5苏　广中早晚中早晚中早晚中早晚中早晚中早晚6陈文颂中早晚中早晚中早晚中早晚中早晚中早晚7张　杰中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚9许　可中早晚中早晚中早晚中早晚中早晚中早晚10左智峰中早晚中早晚中早晚中早晚中早晚中早晚2019六月序号姓名年工作人员值班表712345678910111213141516171819202122232425262728293031##############################################################1邹　勇晚中早晚中早晚中早晚中早晚中早晚中早晚2王　凌晚中早晚中早晚中早晚中早晚中早晚中早晚3王敢登早晚中早晚中早晚中早晚中早晚中早晚中早4肖　虎早晚中早晚中早晚中早晚中早晚中早晚中早5苏　广中早晚中早晚中早晚中早晚中早晚中早晚6陈文颂中早晚中早晚中早晚中早晚中早晚中早晚7张　杰中早晚中早晚中早晚中早晚中早晚中早晚中8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚中9许　可中早晚中早晚中早晚中早晚中早晚中早晚10左智峰中早晚中早晚中早晚中早晚中早晚中早晚2019七月序号姓名年工作人员值班表812345678910111213141516171819202122232425262728293031##############################################################1邹　勇中早晚中早晚中早晚中早晚中早晚中早晚2王　凌中早晚中早晚中早晚中早晚中早晚中早晚3王敢登晚中早晚中早晚中早晚中早晚中早晚中早晚4肖　虎晚中早晚中早晚中早晚中早晚中早晚中早晚5苏　广中早晚中早晚中早晚中早晚中早晚中早晚6陈文颂中早晚中早晚中早晚中早晚中早晚中早晚7张　杰早晚中早晚中早晚中早晚中早晚中早晚中早8郑小鹏早晚中早晚中早晚中早晚中早晚中早晚中早9许　可中早晚中早晚中早晚中早晚中早晚中早晚中10左智峰中早晚中早晚中早晚中早晚中早晚中早晚中2019八月序号姓名年工作人员值班表9123456789101112131415161718192021222324252627282930############################################################1邹　勇中早晚中早晚中早晚中早晚中早晚中早晚2王　凌中早晚中早晚中早晚中早晚中早晚中早晚3王敢登中早晚中早晚中早晚中早晚中早晚中早晚4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚5苏　广中早晚中早晚中早晚中早晚中早晚中早晚6陈文颂中早晚中早晚中早晚中早晚中早晚中早晚7张　杰晚中早晚中早晚中早晚中早晚中早晚中早8郑小鹏晚中早晚中早晚中早晚中早晚中早晚中早9许　可早晚中早晚中早晚中早晚中早晚中早晚中10左智峰早晚中早晚中早晚中早晚中早晚中早晚中2019九月序号姓名年工作人员值班表1012345678910111213141516171819202122232425262728293031##############################################################1邹　勇中早晚中早晚中早晚中早晚中早晚中早晚2王　凌中早晚中早晚中早晚中早晚中早晚中早晚3王敢登中早晚中早晚中早晚中早晚中早晚中早晚4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚5苏　广中早晚中早晚中早晚中早晚中早晚中早晚中6陈文颂中早晚中早晚中早晚中早晚中早晚中早晚中7张　杰晚中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏晚中早晚中早晚中早晚中早晚中早晚中早晚9许　可早晚中早晚中早晚中早晚中早晚中早晚中早10左智峰早晚中早晚中早晚中早晚中早晚中早晚中早2019十月序号姓名年工作人员值班表11123456789101112131415161718192021222324252627282930############################################################1邹　勇中早晚中早晚中早晚中早晚中早晚中早晚2王　凌中早晚中早晚中早晚中早晚中早晚中早晚3王敢登中早晚中早晚中早晚中早晚中早晚中早晚4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚5苏　广早晚中早晚中早晚中早晚中早晚中早晚中6陈文颂早晚中早晚中早晚中早晚中早晚中早晚中7张　杰中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚9许　可晚中早晚中早晚中早晚中早晚中早晚中早10左智峰晚中早晚中早晚中早晚中早晚中早晚中早2019十一月序号姓名年工作人员值班表1212345678910111213141516171819202122232425262728293031##############################################################1邹　勇中早晚中早晚中早晚中早晚中早晚中早晚中2王　凌中早晚中早晚中早晚中早晚中早晚中早晚中3王敢登中早晚中早晚中早晚中早晚中早晚中早晚4肖　虎中早晚中早晚中早晚中早晚中早晚中早晚5苏　广早晚中早晚中早晚中早晚中早晚中早晚中早6陈文颂早晚中早晚中早晚中早晚中早晚中早晚中早7张　杰中早晚中早晚中早晚中早晚中早晚中早晚8郑小鹏中早晚中早晚中早晚中早晚中早晚中早晚9许　可晚中早晚中早晚中早晚中早晚中早晚中早晚10左智峰晚中早晚中早晚中早晚中早晚中早晚中早晚2019十二月序号姓名班次人员早邹　勇早王　凌中王敢登中肖　虎晚苏　广晚陈文颂早王敢登早肖　虎中张　杰中郑小鹏晚邹　勇晚王　凌早张　杰早郑小鹏中许　可中左智峰晚王敢登晚肖　虎早许　可早左智峰中苏　广中陈文颂晚张　杰晚郑小鹏早苏　广早陈文颂中邹　勇中王　凌晚许　可晚左智峰生成排班表班次工时全24早7中7晚102043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100年份2013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100姓名