迟到旷工考勤表怎么做 在考勤表里，通常旷工用什么符号表示？
excel\u600e\u4e48\u5236\u4f5c\u8fdf\u5230\u65e9\u9000\u65f7\u5de5\u7684\u8003\u52e4\u8868\u3000Excel\u91cc\u9762\uff0c\u5982\u4f55\u6839\u636e\u6253\u5f00\u7684\u65f6\u95f4\uff0c\u7b97\u51fa\u5458\u5de5\u662f\u5426\u8fdf\u5230\u3001\u65e9\u9000\u6216\u662f\u65f7\u5de5\u5462?\u90a3\u4e48\u4f60\u77e5\u9053excel\u600e\u4e48\u5236\u4f5c\u8fdf\u5230\u65e9\u9000\u65f7\u5de5\u7684\u8003\u52e4\u8868\u5417?\u4e0b\u9762\u662f\u5b66\u4e60\u5566\u5c0f\u7f16\u6574\u7406\u7684\u4e00\u4e9b\u5173\u4e8eexcel\u5236\u4f5c\u8fdf\u5230\u65e9\u9000\u65f7\u5de5\u7684\u8003\u52e4\u8868\u7684\u76f8\u5173\u8d44\u6599\uff0c\u4f9b\u4f60\u53c2\u8003\u3002
\u3000\u3000excel\u5236\u4f5c\u8fdf\u5230\u65e9\u9000\u65f7\u5de5\u7684\u8003\u52e4\u8868\u7684\u65b9\u6cd5\uff1a
\u3000\u3000\u4e0a\u8868\u4e2d,A\u5217\u8bb0\u5f55\u7684\u662f\u6765\u4e0a\u73ed\u7684\u65f6\u95f4\uff0c\u5373\u8fdb\u5165\u516c\u53f8\u5c31\u6253\u5361\uff0c\u8be5\u65f6\u95f4\u662f\u4e0a\u73ed\u7684\u65f6\u95f4\u3002B\u5217\u662f\u5458\u5de5\u79bb\u5f00\u516c\u53f8\u7684\u65f6\u95f4\uff0c\u5373\u4e0b\u73ed\u65f6\u95f4\u3002\u73b0\u5728\uff0c\u6211\u4eec\u8981\u505a\u7684\u5c31\u662f\u6839\u636e\u8fd9\u4e24\u4e2a\u65f6\u95f4\uff0c\u7b97\u51fa\u5458\u5de5\u662f\u8fdf\u5230\u3001\u65e9\u9000\u8fd8\u662f\u65f7\u5de5\u3002
\u3000\u3000\u4e00\u3001\u8ba1\u7b97\u662f\u5426\u65f7\u5de5
\u3000\u3000\u8981\u8ba1\u7b97\u8fd9\u4e2a\u5c31\u7b80\u5355\u4e86\uff0c\u53ea\u8981\u5458\u5de5\u6ca1\u6709\u4e0a\u5348\u6253\u5f00\u65f6\u95f4\uff0c\u8bf4\u660e\u4ed6\u6ca1\u6709\u6765\u4e0a\u73ed\uff0c\u81ea\u7136\u5c31\u662f\u65f7\u5de5\u3002
\u3000\u3000\u5728E2\u4e2d\u4f7f\u7528\u7684\u516c\u5f0f\u4e3a\uff1a=IF(A2="","\u65f7\u5de5","")\u3000\u7136\u540e\u5f80\u4e0b\u586b\u5145\uff0c\u5373\u53ef\u5f97\u51fa\u662f\u5426\u65f7\u5de5\u3002
\u3000\u3000\u4e8c\u3001\u8ba1\u7b97\u662f\u5426\u8fdf\u5230
\u3000\u3000\u8ba1\u7b97\u662f\u5426\u8fdf\u5230\u7684\u6807\u51c6\u662f\uff1a\u6253\u5f00\u7684\u65f6\u95f4\u662f\u5426\u8d85\u8fc7\u516c\u53f8\u89c4\u5b9a\u7684\u4e0a\u73ed\u65f6\u95f4\uff0c\u8fd9\u91cc\u5047\u5b9a\u4e3a\u4e0a\u53488\uff1a00\uff0c\u8d85\u8fc7\u5c31\u662f\u8fdf\u5230\uff0c\u5426\u5219\u5c31\u662f\u63d0\u524d\u6216\u521a\u597d\u3002
\u3000\u3000\u5728C2\u5355\u5143\u683c\u4e2d\u4f7f\u7528\u7684\u516c\u5f0f\u4e3a\uff1a=IF(A2="","",IF((A2-"8:00")*24*60>0,"\u8fdf\u5230",""))\u3000\u7136\u540e\u5f80\u4e0b\u586b\u5145\uff0c\u5373\u53ef\u5f97\u51fa\u7ed3\u679c\u3002
\u3000\u3000\u5728\u8fd9\u91cc\u5927\u5bb6\u8fd8\u5f97\u7559\u610f\u4e00\u4e0b\uff0c\u8981\u5224\u65ad\u662f\u5426\u8fdf\u5230\uff0c\u9996\u5148\u8981\u5224\u65adA\u5217\u662f\u5426\u4e3a\u7a7a\uff0c\u5982\u679c\u4e3a\u7a7a\u8bf4\u660e\u6ca1\u6709\u5237\u5361\uff0c\u8fd9\u79cd\u60c5\u51b5\u5c5e\u4e8e\u65f7\u5de5\u3002\u5373\u4e0d\u65f7\u5de5\u53c8\u6709\u5237\u5361\u65f6\u95f4\u7684\uff0c\u8fd9\u79cd\u60c5\u5f62\u624d\u7eb3\u5165\u5224\u65ad\u662f\u5426\u4e3a\u8fdf\u5230\u7684\u60c5\u51b5\u3002\u800c\u5224\u65ad\u7684\u6807\u51c6\u662f\u4ee58\uff1a00\u4e3a\u53c2\u7167\u5bf9\u8c61\uff0c\u8d85\u8fc78\uff1a00\u4e3a\u8fdf\u5230\uff0c\u5426\u5219\u90fd\u662f\u6b63\u5e38\u4e0a\u73ed\u7684(\u6bd4\u5982\u63d0\u524d\u6765\u4e5f\u51c6\u65f6\u6765\u90fd\u662f\u6b63\u5e38\u4e0a\u73ed)\u3002
\u3000\u3000\u4e09\u3001\u8ba1\u7b97\u662f\u5426\u65e9\u9000
\u3000\u3000\u8be5\u8ba1\u7b97\u65b9\u6cd5\u548c\u8fdf\u5230\u7684\u8ba1\u7b97\u65b9\u6cd5\u7c7b\u4f3c\uff0c\u5c31\u4e0d\u8fc7\u591a\u4ecb\u7ecd\u4e86\u3002\u516c\u5f0f\u4e3a\uff1a=IF(A2="","",IF((B2-"11:30")*24*60<0,"\u65e9\u9000",""))
\u3000\u3000\u77e5\u8bc6\u62d3\u5c55\uff1a
\u3000\u3000\u521a\u624d\u7684\u516c\u5f0f\u5927\u5bb6\u53ef\u80fd\u5df2\u770b\u5230\u4e86\uff0c\u4e0b\u9762\u6211\u4eec\u518d\u770b\u4e00\u6b21\uff0c\u7136\u540e\u7ed9\u51fa\u89e3\u91ca\u3002
\u3000\u3000\u8fdf\u5230\u516c\u5f0f\uff1a=IF(A2="","",IF((A2-"8:00")*24*60>0,"\u8fdf\u5230",""))
\u3000\u3000\u65e9\u9000\u516c\u5f0f\uff1a=IF(A2="","",IF((B2-"11:30")*24*60<0,"\u65e9\u9000",""))
\u3000\u3000\u516c\u5f0f\u91cc\u9762\u51fa\u73b0\uff1a(A2-"8:00")*24*60>0\u548c(B2-"11:30")*24*60<0\uff0c\u8fd9\u4e2a\u5565\u610f\u601d\u5462?\u8fd9\u4e2a\u662f\u6307\u5c06\u4e24\u4e2a\u65f6\u95f4\u76f8\u51cf\uff0c\u7136\u540e\u4e58\u4ee524\u5c0f\u65f6\u518d\u4e58\u4ee560\u5206\uff0c\u8fd9\u6837\u4f1a\u5f97\u51fa\u4e00\u4e2a\u6570\u5b57\u3002\u4ee5\u8fd9\u4e2a\u6570\u5b57\u4e3a\u53c2\u7167\u5bf9\u8c61\u518d\u6765\u5224\u65ad\u662f\u5426\u8fdf\u5230\u6216\u65e9\u9000\u3002
\u3000\u3000\u6bd4\u5982\uff1a=("8:01"-"8:00")*24*60\u3000\u5927\u5bb6\u60f3\u60f3\uff0c\u8fd9\u4e2a\u7ed3\u679c\u5e94\u8be5\u662f\u591a\u5c11?\u8fd9\u4e2a\u7ed3\u679c\u662f\u62ff8\uff1a01\u51cf\u53bb8\uff1a00\uff0c\u4e24\u4e2a\u65f6\u95f4\u76f8\u51cf\u54e6\u3002
\u3000\u3000\u5982\u679c\u662f\u3000("8:01"-"8:00")\u3000\u90a3\u4e48\u7ed3\u679c\u662f\uff1a0.000694444444444497\u3000\u5b83\u53ea\u662f\u4e00\u4e2a\u5c0f\u6570\u800c\u5df2\uff0c\u5f88\u96be\u5224\u65ad\u662f\u5426\u8fdf\u5230\uff0c\u800c\u6211\u4eec\u9700\u8981\u7684\u662f\uff0c\u4e24\u4e2a\u65f6\u95f4\u76f8\u51cf\u662f\u591a\u5c11\u5206\u949f\uff0c\u53ea\u8981\u5f97\u51fa\u5206\u949f\uff0c\u5c31\u77e5\u9053\u662f\u5426\u8fdf\u5230\uff0c\u6240\u4ee5\uff0c\u516c\u5f0f\u5c31\u4e3a\uff1a=("8:01"-"8:00")*24*60
\u3000\u3000\u770b\u5230\u4e86\u5427\uff0c\u518d\u4e58\u4ee524\u518d\u4e58\u4ee560\uff0c\u5c31\u5f97\u51fa\u5206\u949f\u6570\u4e86\u3002\u5982\u679c\u5f97\u51fa\u7684\u5206\u949f\u6570\u7b49\u4e8e0\uff0c\u8bf4\u660e\u8d85\u8fc78\u70b9\u624d\u6253\u5f00\uff0c\u80af\u5b9a\u5c31\u8fdf\u5230\u4e86\u561b\uff0c\u5982\u679c\u6570\u7b49\u4e8e\u6216\u5c0f\u4e8e0\uff0c\u8bf4\u660e\u662f\u51c6\u65f6\u6216\u63d0\u524d\u4e0a\u73ed\uff0c\u672a\u8fdf\u5230\u3002\u597d\u4e86\uff0c\u5176\u5b83\u7684\u90fd\u662f\u7c7b\u4f3c\u7684\uff0c\u5c31\u4e0d\u518d\u89e3\u91ca\u4e86\u3002
excel\u600e\u4e48\u5236\u4f5c\u8fdf\u5230\u65e9\u9000\u65f7\u5de5\u7684\u8003\u52e4\u8868 http://www.xuexila.com/diannao/995822.html
\u65f7\u5de5\u6216\u8005\u7f3a\u52e4\u4e00\u822c\u4f7f\u7528\u201cX\u201d\u53f7\u8868\u793a\u3002
\u7528\u7b26\u53f7\u8868\u793a\uff1a\u51fa\u52e4(\u221a)\u3001\u65f7\u5de5\uff08X\uff09\u3001\u6b63\u4f11\uff08\u25c6\uff09\u3001\u4e8b\u5047\u25c7\u3001\u51fa\u5dee\uff08\u25bc\uff09\u3001\u6362\u4f11\uff08\u25bd\uff09\u3001\u4e27\u5047\uff08\u25cf\uff09\u3001\u4ea7\u5047\uff08\u25cb\uff09\u3001\u75c5\u5047\uff08\u203b\uff09\u5a5a\u5047\uff08\u25ce\uff09\u3002\u8003\u52e4\u8868\u7684\u7b26\u53f7\u76ee\u524d\u5c1a\u65e0\u7edf\u4e00\u89c4\u8303\u7684\u7b26\u53f7\uff0c\u4e0d\u540c\u7684\u516c\u53f8\u53ef\u80fd\u4e0d\u4e00\u6837\u3002
\u7528\u5b57\u6bcd\u8868\u793a\uff1ab\u4ee3\u8868\u7684\u662f\u75c5\u5047\uff0cs\u4ee3\u8868\u7684\u662f\u4e8b\u5047\uff0cT\u4ee3\u8868\u7684\u662f\u52a0\u73ed\uff0cd\u4ee3\u8868\u7684\u662f\u5012\u4f11\uff0cc\u4ee3\u8868\u7684\u662f\u8fdf\u5230\uff0cz\u4ee3\u8868\u7684\u662f\u65e9\u9000\uff0ct\u4ee3\u8868\u7684\u662f\u7279\u4f11\uff08\u5a5a\u5047\u3001\u4ea7\u5047\u7b49\uff09\uff0cq\u4ee3\u8868\u7684\u662f\u7f3a\u52e4\u3002
\u6269\u5c55\u8d44\u6599
\u8003\u52e4\u8868\u662f\u516c\u53f8\u5458\u5de5\u6bcf\u5929\u4e0a\u73ed\u7684\u51ed\u8bc1\uff0c\u4e5f\u662f\u5458\u5de5\u9886\u5de5\u8d44\u7684\u51ed\u8bc1\uff0c\u56e0\u4e3a\u5b83\u8bb0\u5f55\u4e86\u5458\u5de5\u4e0a\u73ed\u7684\u5929\u6570\u3002\u8003\u52e4\u8868\u4e2d\u6709\u5177\u4f53\u7684\u4e0a\u4e0b\u73ed\u65f6\u95f4\uff0c\u5305\u62ec\u8fdf\u5230\u3001\u65e9\u9000\u3001\u65f7\u5de5\u3001\u75c5\u5047\u3001\u4e8b\u5047\u3001\u4f11\u5047\u7684\u60c5\u51b5\u3002\u8003\u52e4\u8868\u53ef\u4ee5\u4f5c\u4e3a\u6587\u672c\u7684\u201c\u8bc1\u636e\u201d\u3002
\u5458\u5de5\u8003\u52e4\u8868\u5e38\u7528\u5b57\u6bb5\u5305\u62ec\uff1a\u5355\u4f4d\u540d\u79f0\u3001\u90e8\u95e8\u540d\u79f0\u3001\u7f16\u53f7\u3001\u59d3\u540d\u3001\u4e0a\u73ed\u65f6\u95f4\u3001\u4e0b\u73ed\u65f6\u95f4\u3001\u8fdf\u5230\u3001\u65e9\u9000\u3001\u65f7\u5de5\u3001\u5b9e\u51fa\u52e4\u3001\u5907\u6ce8\u3001\u5206\u7ba1\u9886\u5bfc\u3001\u90e8\u95e8\u8d1f\u8d23\u4eba\u7b49\u3002
\u53c2\u8003\u8d44\u6599\u6765\u6e90\uff1a\u767e\u5ea6\u767e\u79d1-\u8003\u52e4\u8868
你可以按31天制出表格来，上面员工姓名有迟到栏，旷工栏，如有迟到的你在迟到栏里填上迟到时间，旷工在旷工栏里填上旷工即可。
我认为，可以做烤勤表，表可列有，姓名，出工，迟到t， 早退，事假，病假，旷工，等可以详细记录职工的考勤情况
迟到旷工考勤表。迟到的话直接迟到几分钟就写几分钟，比如迟到三分钟。可以写-3。
迟到多少分钟就写多少分钟，旷工一天就是旷工一天，旷工半天就写大半天
绛旓細璁剧疆涓哄簭鍒楋紝鏁版嵁楠岃瘉鏉ユ簮閫夋嫨鑰冨嫟绗﹀彿銆8.缁欒冨嫟绗﹀彿鍗曞厓鏍兼坊鍔燙OUNTIF鍏紡 杩熷埌锛=COUNTIF(C4:AG4,"鈼")璇峰亣锛=COUNTIF(V5C4:AG4,"/")鍑哄嫟锛=COUNTIF(C4:AG4,"鈭")*AH4 鏃峰伐锛=COUNTIF(C4:AG4,"脳")9.瀹屾垚涓浠鑰冨嫟琛灏卞畬鎴愪簡!
绛旓細1銆佸崟浣嶅悕绉 2銆侀儴闂ㄥ悕绉 3銆佺紪鍙 4銆佸鍚 5銆佷笂鐝椂闂 6銆佷笅鐝椂闂 7銆杩熷埌 8銆佹棭閫 9銆鏃峰伐 10銆佸疄鍑哄嫟 11銆佸娉 12銆佸垎绠￠瀵 13銆侀儴闂ㄨ礋璐ｄ汉銆鑰冨嫟琛涓哄叕鍙稿憳宸ユ瘡澶╀笂鐝殑璇佹嵁锛屼篃鏄憳宸ラ宸ヨ祫鐨勫嚟璇侊紝鍥犱负瀹冭褰曞憳宸ヤ笂鐝殑澶╂暟銆傝繜鍊/鏃╅/鏃峰伐/鐥呭亣/浜嬪亣/浼戝亣鐨勬湁鏂囨湰鐨勨滆瘉鎹濄鑰冨嫟鎶...
绛旓細1銆佸嚭鍕:/杩熷埌:涓涓渾涓婇潰涓鏉″彸鍊炬枩绾挎棭閫:涓涓渾閲岄潰涓涓弶鐥呭亣:♁浜嬪亣:灏忎笁瑙掑舰鏃峰伐:X鍏亣:G銆
绛旓細1銆佺偣鍑荤數鑴戞闈笂鐨別xcel琛ㄦ牸銆2銆佸湪绗竴琛岃緭鍏ヨ冨嫟琛ㄧ殑琛ㄥご鍐呭銆3銆佸湪绗簩琛岃緭鍏ヨ冨嫟鐨勫叿浣撶殑鍐呭锛氬鍚嶏紝杩熷埌銆佽鍋囥佹椃宸ュ拰鏍稿绛惧瓧銆4銆佺敤榧犳爣閫変腑闇瑕佽皟鑺傝楂樼殑鍖哄煙銆5銆佸彸鍑婚紶鏍囷紝鎵惧埌琛岄珮銆6銆佽緭鍏ュ悎閫傜殑琛岄珮锛岀劧鍚庣偣鍑荤‘瀹氥7銆佸琛ㄦ牸鍔犱笂妗嗙嚎銆8銆佹妸琛ㄥご鏂囧瓧杩涜灞呬腑锛屽苟涓旀枃瀛楄缃垚鍔犵矖灏...
绛旓細杩熷埌鏃峰伐鐨勮冨嫟琛ㄦ庝箞鍋氾紝棣栧厛浠ユ湀搴︿负鍗曚綅鍒朵綔鎶ヨ〃锛屽舰鎴愭槑纭殑瑙勭珷鍒跺害锛岃繜鍒颁负澶氶暱鏃堕棿锛屾椃宸ヤ负瓒呰繃澶氶暱鏃堕棿銆傛湭闃叉閲嶅悕鐨勪汉鍛橈紝寤鸿姣忎釜浜虹敤涓涓崟鐙殑缂栧彿銆傛瘡涓汉鎵杩濆弽鐨勮绔犲埗搴﹀彲浠ョ敤瀛楁瘝浠ｅ彿鏉ュ仛銆
绛旓細1銆佺偣鍑荤數鑴戞闈笂鐨別xcel琛ㄦ牸銆2銆佸湪绗竴琛岃緭鍏鑰冨嫟琛鐨勮〃澶村唴瀹广3銆佸湪绗簩琛岃緭鍏ヨ冨嫟鐨勫叿浣撶殑鍐呭锛氬鍚嶏紝杩熷埌銆佽鍋囥鏃峰伐鍜屾牳瀵圭瀛椼4銆佺敤榧犳爣閫変腑闇瑕佽皟鑺傝楂樼殑鍖哄煙銆5銆佸彸鍑婚紶鏍囷紝鎵惧埌琛岄珮銆6銆佽緭鍏ュ悎閫傜殑琛岄珮锛岀劧鍚庣偣鍑荤‘瀹氥7銆佸琛ㄦ牸鍔犱笂妗嗙嚎銆8銆佹妸琛ㄥご鏂囧瓧杩涜灞呬腑锛屽苟涓旀枃瀛楄缃垚鍔犵矖灏...
绛旓細鎴戜滑鑰冨嫟琛ㄨ繜鍒鐢ㄥ渾鍦堚棆琛ㄧず锛屾甯稿嚭鍕ょ敤鎵撳嬀✓琛ㄧず锛屾棭閫鐢ㄤ笁瑙掔鍙封柍琛ㄧず锛鏃峰伐鐢ㄦ墦鍙壝楄〃绀猴紝缂哄嫟鐢ㄦ鏂瑰舰琛ㄧず銆傛槸涓嶆槸姣忎釜鍏徃涓嶄竴鏍凤紝杩欎釜灏卞緱鏍规嵁鍚勮嚜鍏徃鍋氳瀹氾紝鍏跺疄鍏抽敭鏄紑濮鎬庝箞瀹氫箟鍚э紝鎴戣寰楁垜浠殑琛ㄧず鏂瑰紡灏卞緢绠鍗曟槑浜嗐傝冨嫟琛ㄨ繜鍒扮敤浠涔堢鍙疯〃绀 鍑哄嫟锛/ 杩熷埌锛氫竴涓渾涓婇潰涓鏉″彸鍊...
绛旓細excel鍒朵綔杩熷埌鏃╅鏃峰伐鐨鑰冨嫟琛鐨勬柟娉曪細涓婅〃涓,A鍒楄褰曠殑鏄潵涓婄彮鐨勬椂闂达紝鍗宠繘鍏ュ叕鍙稿氨鎵撳崱锛岃鏃堕棿鏄笂鐝殑鏃堕棿銆侭鍒楁槸鍛樺伐绂诲紑鍏徃鐨勬椂闂达紝鍗充笅鐝椂闂淬傜幇鍦紝鎴戜滑瑕佸仛鐨勫氨鏄牴鎹繖涓や釜鏃堕棿锛岀畻鍑哄憳宸ユ槸杩熷埌銆佹棭閫杩樻槸鏃峰伐銆備竴銆佽绠楁槸鍚︽椃宸 瑕佽绠楄繖涓氨绠鍗曚簡锛屽彧瑕佸憳宸ユ病鏈変笂鍗堟墦寮鏃堕棿锛岃鏄庝粬娌...
绛旓細1銆佺偣鍑荤數鑴戞闈笂鐨別xcel琛ㄦ牸銆2銆佸湪绗竴琛岃緭鍏鑰冨嫟琛鐨勮〃澶村唴瀹广3銆佸湪绗簩琛岃緭鍏ヨ冨嫟鐨勫叿浣撶殑鍐呭锛氬鍚嶏紝杩熷埌銆佽鍋囥鏃峰伐鍜屾牳瀵圭瀛椼4銆佺敤榧犳爣閫変腑闇瑕佽皟鑺傝楂樼殑鍖哄煙銆5銆佸彸鍑婚紶鏍囷紝鎵惧埌琛岄珮銆6銆佽緭鍏ュ悎閫傜殑琛岄珮锛岀劧鍚庣偣鍑荤‘瀹氥7銆佸琛ㄦ牸鍔犱笂妗嗙嚎銆8銆佹妸琛ㄥご鏂囧瓧杩涜灞呬腑锛屽苟涓旀枃瀛楄缃垚鍔犵矖灏...
绛旓細1銆佺偣鍑荤數鑴戞闈笂鐨別xcel琛ㄦ牸銆2銆佸湪绗竴琛岃緭鍏鑰冨嫟琛鐨勮〃澶村唴瀹广3銆佸湪绗簩琛岃緭鍏ヨ冨嫟鐨勫叿浣撶殑鍐呭锛氬鍚嶏紝杩熷埌銆佽鍋囥鏃峰伐鍜屾牳瀵圭瀛椼4銆佺敤榧犳爣閫変腑闇瑕佽皟鑺傝楂樼殑鍖哄煙銆5銆佸彸鍑婚紶鏍囷紝鎵惧埌琛岄珮銆6銆佽緭鍏ュ悎閫傜殑琛岄珮锛岀劧鍚庣偣鍑荤‘瀹氥7銆佸琛ㄦ牸鍔犱笂妗嗙嚎銆8銆佹妸琛ㄥご鏂囧瓧杩涜灞呬腑锛屽苟涓旀枃瀛楄缃垚鍔犵矖灏...
