我在做考勤表英文

负责人签字 responsible officer (signature)出勤Attendance公休Official holiday 病假 Sick leave事假 private affair leave 旷工Absenteeism迟到be late倒休 take a work day off in exchange of a holiday 除上述情况均手写 In addition to the above conditions are handwritten

原数据在A列，B列输入=IF(OR((AND((A1-INT(A1))>TIME(8,0,0),(A1-INT(A1))TIME(13,30,0),(A1-INT(A1))