上班时间为白班8:00-20:00;8:00-18:30,10:00-22:00;夜班20:00-8:00,17:00-02:00平日加班设置8:00-20:00加班2.5H,8:00-18:30加班1H,10:00-22:00加班2.5H,20:00-8:00加班2.5H周六日加班设置8:00-20:00加班10.5H,8:00-17:00加班8H,20:00-8:00加班10.5H.平时上下班有打卡时间,考勤计算也会有迟到、早退扣款。下图为考勤机上的打卡时间及统计表
ç»è®¡å çæ¶é´ï¼ä¸è¬ä½¿ç¨excelå½æ°å°±å¯ä»¥æå®ï¼
å»åç»è®¡ä¹åè¦å æå·¥ä½æ¶é´ç»è®¡è¡¨çå表å¶ä½å¥½ï¼æ们å¨ååºç¡è¡¨çæ¶åæ好æ¯æä¸åä¸ä¸çæ¶é´åä¸åä¸ä¸çæ¶é´åå¼å¡«åï¼å¦ä¸å¾ï¼
å¨ä¸åä¸çæ¶é´åæå ¥ä¸åâä¸åæ¶é´å·®âï¼å¨ä¸åä¸çæ¶é´åé¢æå ¥ä¸åâä¸åæ¶é´å·®â
å 计ç®ä¸åæ¶é´å·®ï¼
å¨âä¸åæ¶é´å·®âä¸é¢çåå æ ¼æå ¥âMINâå½æ°ï¼
ç¼è¾å½æ°æ°å¼ï¼Number1:å¼ç¨F3åå æ ¼ï¼Number2ï¼å¡«åè§å®ä¸åä¸çæ¶é´"12ï¼00"(è±æç¶æä¸çåå¼å·)
å¨MINå½æ°åé¢åå»MAXå½æ°ï¼
maxå½æ°æ°å¼å¡«åï¼Number1:å¼ç¨D3åå æ ¼ï¼Number2ï¼å¡«åè§å®ä¸åä¸çæ¶é´"8ï¼30"(è±æç¶æä¸çåå¼å·)ï¼æå¨å¡«å æå¾ä¸æå³å¯ã
计ç®ä¸åæ¶é´å·®ï¼
å¨âä¸åæ¶é´å·®âä¸é¢çåå æ ¼æå ¥âMINâå½æ°ï¼
ç¼è¾å½æ°æ°å¼ï¼Number1:å¼ç¨H3åå æ ¼ï¼Number2ï¼å¡«åè§å®ä¸åä¸çæ¶é´"16ï¼30"(è±æç¶æä¸çåå¼å·)
å¨MINå½æ°åé¢åå»MAXå½æ°ï¼
maxå½æ°æ°å¼å¡«åï¼Number1:å¼ç¨G3åå æ ¼ï¼Number2ï¼å¡«åè§å®ä¸åä¸çæ¶é´"13ï¼15"(è±æç¶æä¸çåå¼å·)ï¼æå¨å¡«å æå¾ä¸æå³å¯ã
å¨âä¸åæ¶é´å·®âåé¢ è¾å ¥âå计æ¶é´âï¼å¨J3ä¸è¾å ¥å ¬å¼ï¼=F3+I3ï¼å车确认ï¼æå¨å¡«å 表填å å³å¯
追é®æ¨å¥½ï¼æè°¢æ¨ç帮å©ï¼å¨è®¾ç½®å
¬å¼çè¿ç¨ä¸ï¼åç°å½æ设置ä¸çæ¶é´ä¸º22:00æ¶ï¼æå¡æ¶é´æ£å¥½æ¯æ´ç¹ï¼åºä¸æ¥ç»æï¼è¿ä¸ªè¦ææ ·å¤çï¼