4.È·ÈÏ¡°»æÍ¼¡±¹¤¾ßÀ¸Éϵġ°Ñ¡Ôñ¶ÔÏó¡±°´Å¥±»Ñ¡ÖУ¬µ¥»÷¡°Ï°ࡱ°´Å¥£¬È»ºó°´×¡¡°Shift¡±¼üÔÙµ¥»÷¡°Éϰࡱ°´Å¥£¬½«Á½¸ö°´Å¥Í¬Ê±Ñ¡ÖС£µ¥»÷¡°Ctrl¡±¼ü£¬ÓÃÊó±ê½«Ñ¡ÖеÄÁ½¸ö°´Å¥Í϶¯¸´ÖƵ½BÁÐµÄÆäÓ൥Ԫ¸ñÖС£×îºóЧ¹ûÈçͼ4¡£
ͼ4 ´´½¨¡°ÉÏ¡¢Ï°ࡱ°´Å¥ºê
ËÄ¡¢¼Ç¼³öÇÚ
Ñ¡Öдý²åÈëÉÏϰàʱ¼äµÄµ¥Ôª¸ñ£¬µ¥»÷ͬһÐÐÖеġ°Éϰࡱ»ò¡°Ï°ࡱ°´Å¥¼´¿É¡£ÔÚµ¥»÷¡°Éϰࡱ¡¢¡°Ï°ࡱ°´Å¥Ê±»á·µ»ØºÜ³¤Ò»´®Êý×Ö£¬ÆäʵÎÒÃÇÖ»ÐèÊäÈëÖîÈç¡°13:30¡±ÕâÑùµÄʱ¼ä¼´¿É¡£ µ¥»÷¡°¸ñʽ¡úµ¥Ôª¸ñ¡±²Ëµ¥ÏÔÚµ¯³öÀ´µÄ¡°µ¥Ôª¸ñ¸ñʽ¡±¶Ô»°¿òÖеãÑ¡¡°Êý×Ö¡±Ñ¡Ï£¬ÔÚ·ÖÀà¿òÖеãÑ¡¡°Ê±¼ä¡±£¬ÔÚ¡°ÀàÐÍ¡±¿òÖеãÑ¡¡°13:30¡±£¬×îºóµ¥»÷¡°È·¶¨¡±¼´¿É¡£
Òª°Ñ³öÇڼǼÓɹ«Ê½½á¹ûת»»³É¾ßÌåµÄʱ¼äÊýÖµ£¬·ñÔòµ±¹«Ê½±»ÖØÐ¼ÆËãºó£¬Æä½á¹û½«¸ü¸Ä¡£Ñ¡ÖбíÖеÄËùÓÐÊý¾Ýµ¥Ôª¸ñ£¬µ¥»÷ÓÒ¼üÑ¡Ôñ¡°¸´ÖÆ¡±£¬µãÑ¡¡°±à¼¡úÑ¡ÔñÐÔÕ³Ìù¡±²Ëµ¥ÏÔÚ¡°Ñ¡ÔñÐÔÕ³Ìù¡±¶Ô»°¿òÖÐÑ¡ÖС°ÊýÖµ¡±ÏȻºóµ¥»÷¡°È·¶¨¡±¡£
Î塢ͳ¼Æ½á¹û
1.ÔÚÈÕÆÚÐÐÖ®ºóµÄµ¥Ôª¸ñÖÐÒÀ´ÎÊäÈë¡°³Ùµ½¡±¡¢¡°ÔçÍË¡±¡¢¡°²¡¼Ù¡±¡¢¡°Ê¼١±µÈÐèҪͳ¼ÆµÄÏîÄ¿¡£²¢½«Õ⼸ÁÐÖеĵ¥Ôª¸ñÉÏÏÂÁ½Á½ºÏ²¢£¬Ê¹Ö®¶ÔÓ¦ÓÚÐÕÃûÐУ¨Èçͼ5£©¡£
ͼ5 ´´½¨Ïà¹ØÍ³¼ÆÏîÄ¿
2.µ¥»÷µ¥Ôª¸ñY2£¬È»ºó¼üÈ빫ʽ¡°=COUNTIF(C2:X2,">8£º30")¡±£¨ÕâÀï¼ÙÉèÉϰàʱ¼äΪ8:30£©£¬²¢°´»Ø³µ¼ü£¬Z2µ¥Ôª¸ñÖбã»á³öÏÖÑ¡ÖÐÔ±¹¤ËùÓгÙÓÚ8:30ÉϰàµÄ¹¤×÷ÈÕÌìÊý¡£Í¬ÀíÔÚZ2µ¥Ôª¸ñÖÐÊäÈ빫ʽ¡°=COUNTIF(C3:X3,">17£º00")¡±(¼ÙÉèϰàʱ¼äΪ17:00)£¬²¢°´»Ø³µ¼ü£¬Z2µ¥Ôª¸ñÖбã»á³öÏÖÑ¡ÖÐÔ±¹¤ËùÓÐÔçÓÚ17:00ϰàµÄ¹¤×÷ÈÕÌìÊý¡£
3.µ¥»÷AB2µ¥Ôª¸ñÊäÈ빫ʽ¡°=COUNTIF(C2:X3,"ʼÙ")¡±£¬²¢°´»Ø³µ¼üÈ·ÈÏ£¬AB2µ¥Ôª¸ñÖбã³öÏÖÁËÑ¡ÖÐÔ±¹¤±¾ÔµÄʼٴÎÊý¡£
4.ÆäËûÈ˵Äͳ¼Æ·½·¨¿ÉÒÔÀûÓÃExcelµÄ¹«Ê½ºÍÏà¶ÔÒýÓù¦ÄÜÀ´Íê³É¡£
5.µ¥»÷¡°¹¤¾ß¡úÑ¡Ï²Ëµ¥ÏÔÚµ¯³öµÄ¶Ô»°¿òÖеãÑ¡¡°ÖØÐ¼ÆË㡱ѡÏ£¬²¢µ¥»÷¡°ÖØËã»î¶¯¹¤×÷±í¡±°´