ãExceléé¢ï¼å¦ä½æ ¹æ®æå¼çæ¶é´ï¼ç®åºåå·¥æ¯å¦è¿å°ãæ©éææ¯æ·å·¥å¢?é£ä¹ä½ ç¥éexcelæä¹å¶ä½è¿å°æ©éæ·å·¥çèå¤è¡¨å?ä¸é¢æ¯å¦ä¹ å¦å°ç¼æ´ççä¸äºå
³äºexcelå¶ä½è¿å°æ©éæ·å·¥çèå¤è¡¨çç¸å
³èµæï¼ä¾ä½ åèã
ããexcelå¶ä½è¿å°æ©éæ·å·¥çèå¤è¡¨çæ¹æ³ï¼
ããä¸è¡¨ä¸,Aåè®°å½çæ¯æ¥ä¸ççæ¶é´ï¼å³è¿å
¥å
¬å¸å°±æå¡ï¼è¯¥æ¶é´æ¯ä¸ççæ¶é´ãBåæ¯å工离å¼å
¬å¸çæ¶é´ï¼å³ä¸çæ¶é´ãç°å¨ï¼æ们è¦åçå°±æ¯æ ¹æ®è¿ä¸¤ä¸ªæ¶é´ï¼ç®åºåå·¥æ¯è¿å°ãæ©éè¿æ¯æ·å·¥ã
ããä¸ã计ç®æ¯å¦æ·å·¥
ããè¦è®¡ç®è¿ä¸ªå°±ç®åäºï¼åªè¦å工没æä¸åæå¼æ¶é´ï¼è¯´æä»æ²¡ææ¥ä¸çï¼èªç¶å°±æ¯æ·å·¥ã
ããå¨E2ä¸ä½¿ç¨çå
¬å¼ä¸ºï¼=IF(A2="","æ·å·¥","")ãç¶åå¾ä¸å¡«å
ï¼å³å¯å¾åºæ¯å¦æ·å·¥ã
ããäºã计ç®æ¯å¦è¿å°
ãã计ç®æ¯å¦è¿å°çæ åæ¯ï¼æå¼çæ¶é´æ¯å¦è¶
è¿å
¬å¸è§å®çä¸çæ¶é´ï¼è¿éåå®ä¸ºä¸å8ï¼00ï¼è¶
è¿å°±æ¯è¿å°ï¼å¦åå°±æ¯æåæå好ã
ããå¨C2åå
æ ¼ä¸ä½¿ç¨çå
¬å¼ä¸ºï¼=IF(A2="","",IF((A2-"8:00")*24*60>0,"è¿å°",""))ãç¶åå¾ä¸å¡«å
ï¼å³å¯å¾åºç»æã
ããå¨è¿é大家è¿å¾çæä¸ä¸ï¼è¦å¤ææ¯å¦è¿å°ï¼é¦å
è¦å¤æAåæ¯å¦ä¸ºç©ºï¼å¦æ为空说æ没æå·å¡ï¼è¿ç§æ
åµå±äºæ·å·¥ãå³ä¸æ·å·¥åæå·å¡æ¶é´çï¼è¿ç§æ
å½¢æ纳å
¥å¤ææ¯å¦ä¸ºè¿å°çæ
åµãèå¤æçæ åæ¯ä»¥8ï¼00为åç
§å¯¹è±¡ï¼è¶
è¿8ï¼00为è¿å°ï¼å¦åé½æ¯æ£å¸¸ä¸çç(æ¯å¦æåæ¥ä¹åæ¶æ¥é½æ¯æ£å¸¸ä¸ç)ã
ããä¸ã计ç®æ¯å¦æ©é
ãã该计ç®æ¹æ³åè¿å°ç计ç®æ¹æ³ç±»ä¼¼ï¼å°±ä¸è¿å¤ä»ç»äºãå
¬å¼ä¸ºï¼=IF(A2="","",IF((B2-"11:30")*24*60<0,"æ©é",""))
ããç¥è¯æå±ï¼
ããåæçå
¬å¼å¤§å®¶å¯è½å·²çå°äºï¼ä¸é¢æ们åçä¸æ¬¡ï¼ç¶åç»åºè§£éã
ããè¿å°å
¬å¼ï¼=IF(A2="","",IF((A2-"8:00")*24*60>0,"è¿å°",""))
ããæ©éå
¬å¼ï¼=IF(A2="","",IF((B2-"11:30")*24*60<0,"æ©é",""))
ããå
¬å¼éé¢åºç°ï¼(A2-"8:00")*24*60>0å(B2-"11:30")*24*60<0ï¼è¿ä¸ªå¥ææå¢?è¿ä¸ªæ¯æå°ä¸¤ä¸ªæ¶é´ç¸åï¼ç¶åä¹ä»¥24å°æ¶åä¹ä»¥60åï¼è¿æ ·ä¼å¾åºä¸ä¸ªæ°åã以è¿ä¸ªæ°å为åç
§å¯¹è±¡åæ¥å¤ææ¯å¦è¿å°ææ©éã
ããæ¯å¦ï¼=("8:01"-"8:00")*24*60ã大家æ³æ³ï¼è¿ä¸ªç»æåºè¯¥æ¯å¤å°?è¿ä¸ªç»ææ¯æ¿8ï¼01åå»8ï¼00ï¼ä¸¤ä¸ªæ¶é´ç¸åå¦ã
ããå¦ææ¯ã("8:01"-"8:00")ãé£ä¹ç»ææ¯ï¼0.000694444444444497ãå®åªæ¯ä¸ä¸ªå°æ°èå·²ï¼å¾é¾å¤ææ¯å¦è¿å°ï¼èæ们éè¦çæ¯ï¼ä¸¤ä¸ªæ¶é´ç¸åæ¯å¤å°åéï¼åªè¦å¾åºåéï¼å°±ç¥éæ¯å¦è¿å°ï¼æ以ï¼å
¬å¼å°±ä¸ºï¼=("8:01"-"8:00")*24*60
ããçå°äºå§ï¼åä¹ä»¥24åä¹ä»¥60ï¼å°±å¾åºåéæ°äºãå¦æå¾åºçåéæ°çäº0ï¼è¯´æè¶
è¿8ç¹ææå¼ï¼è¯å®å°±è¿å°äºåï¼å¦ææ°çäºæå°äº0ï¼è¯´ææ¯åæ¶ææåä¸çï¼æªè¿å°ã好äºï¼å
¶å®çé½æ¯ç±»ä¼¼çï¼å°±ä¸å解éäºã
excelæä¹å¶ä½è¿å°æ©éæ·å·¥çèå¤è¡¨
http://www.xuexila.com/diannao/995822.html