ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§ó§ï¹Lªº®æ¦¡¦p¦óÅý¥L¥[Á`?(Hsieh¤j¤j¸Ñ¨M¤F§ÚªººÃ´b¡AÁÂÁ§A)

§ó§ï¹Lªº®æ¦¡¦p¦óÅý¥L¥[Á`?(Hsieh¤j¤j¸Ñ¨M¤F§ÚªººÃ´b¡AÁÂÁ§A)

¥»©«³Ì«á¥Ñ av8d ©ó 2011-8-18 22:29 ½s¿è

ÀɮפU¸ü¡G w.rar (14.97 KB)

¥´¶}Àɮ׫á¡A§A·|¬Ý¨ì"¤é´Á"©M"®É¶¡"ªº®æ¦¡³£¬O¦Û­qªº¡A¤è«K§@·~¦Ó©wªº¡A¥i¬O²{¦b°ÝÃD¨Ó¤F¡A§Ú¸Ó¦p¦ó¤U§PÂ_¬OÅý¥L­Ì°µ¥[Á`©O?

­º¥ý§Ú§â§Úªº»Ý¨D´£¥X¨Ó¡A­º¥ý¬Ý¨ì³Ì­«­nªº¤T­ÓÄæ¦ì¡A§Ú§Æ±æ¯à°÷¤U§PÂ_µ¹¥L­Ì¦Û°Ê§P§O¡A°e¹F¤é¡A°e¹F®É¡Aªá©±

°e¹F¤é¡G·í"¨Æ¥Ñ"¥X²{"¬¡°Ê"³o­ÓÃöÁä¦r®É¡A¥h§PÂ_"®É¶¡"¬O¤£¬O¶W¹L¤¤¤È12:00¡A
¦pªG¬O¡Aª½±µ§ì¨úBÄ檺­È¶ñ¤J
¦pªG¤£¬O¡Aª½±µ§ì¨úBÄ檺­È¶ñ¤J¨Ã-1¤Ñ
¦pªG·í"¨Æ¥Ñ"¥¼¥X²{"¬¡°Ê"³o­ÓÃöÁä¦r®É¡Aª½±µ§ì¨úBÄ檺­È¶ñ¤J§Y¥i¡A

¡° Á`µ²´N¬O·í"¨Æ¥Ñ"¥X²{"¬¡°Ê"³o­ÓÃöÁä¦r®É¡A¥h§PÂ_"®É¶¡"¬O¤£¬O¶W¹L¤¤¤È12:00¡A¦pªG¤£¬O¡Aª½±µ§ì¨úBÄ檺­È¶ñ¤J¨Ã-1¤Ñ¡A¨ä¾lªº«hª½±µ§ì¨úBÄ檺­È¶ñ¤J¡C ¡°


°e¹F®É¶¡¡G·í"¨Æ¥Ñ"¥X²{"¬¡°Ê"³o­ÓÃöÁä¦r®É¡A¥h§PÂ_"®É¶¡"¬O¤£¬O¶W¹L¤¤¤È12:00¡A
¦pªG¬O¡Aª½±µ§ì¨úCÄ檺­È¶ñ¤J¨Ã-1¤p®É
¦pªG¤£¬O¡Aª½±µ¶ñ¤J17:00
¦pªG·í"¨Æ¥Ñ"¥¼¥X²{"¬¡°Ê"³o­ÓÃöÁä¦r®É¡Aª½±µ§ì¨úCÄ檺­È¶ñ¤J¨Ã-1¤p®É§Y¥i¡A

¡° Á`µ²´N¬O·í"¨Æ¥Ñ"¥X²{"¬¡°Ê"³o­ÓÃöÁä¦r®É¡A¥h§PÂ_"®É¶¡"¬O¤£¬O¶W¹L¤¤¤È12:00¡A¦pªG¤£¬O¡Aª½±µ¶ñ¤J17:00¡A¨ä¾lªº«hª½±µ§ì¨úCÄ檺­È¶ñ¤J¨Ã-1¤p®É¡C ¡°
¥H¤W§Ú¹Á¸Õ¥Î¹L+Timer(1,0,0)¡A¥H¥¿±`ªº®É¶¡¬O¥i¥H¼W¥[¤@¤p®É¡A¥i¬O¥L¬O¯S©w®æ¦¡¡A§Ú´NµL±q°µ°_¤F¡C


ªá©±¡G·í"¬¡°Ê¦aÂI"¤K¼w""¤¤Ãc"ªº®É­Ô¶ñ¤J§ùÃYªá
·í"¬¡°Ê¦aÂI"®ç¶é"ªº®É­Ô¶ñ¤J³â¥zªá
Ãö©óªá©±ªº³¡¤À§Ú¦³¹Á¸Õ°µ¹L(¦p¤U)¡A¬O¥i¦æªº¡A¤£ª¾¹D¦³¨S¦³¤j¤j¦³§ó²µu§ó§Öªº¤è¦¡©O?
K2=LOOKUP(,-FIND({"¤K¼w","¤¤Ãc","®ç¶é¥«"},E2),{"§ùÃYªá","§ùÃYªá","³â¥zªá"})


¦hÁ¤j¤j¨ÓÆ[¬Ý¤å³¹¡A­Y¬OÁÙ¦³¤°»ò¬Ý¤£À´±o¡AÅwªï´£¥X¡A¦A¦¸·PÁ¦U¦ì¸ê²`¤j¤jªºÃö·Ó¡I

¦^´_ 1# av8d


G2=IF(ISERROR(FIND("¬¡°Ê",$D2))+(ISNUMBER(FIND("¬¡°Ê",$D2))*(--TEXT(C2,"00!:00")>0.5)),B2,B2-1)
H2=IF(ISERROR(FIND("¬¡°Ê",$D2))+(ISNUMBER(FIND("¬¡°Ê",$D2))*(--TEXT(C2,"00!:00")>0.5)),C2-100,1700)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ¤£¦n·N«ä~¦A¦¸¥´ÂZ~¥Ñ©ó§Úªº¸ê®Æ¬O¤é´Á®æ¦¡~©Ò¥H¨C¦¸¦b¨C¤ë1¤éªº®É­Ô³£·|¥X²{¿ù»~~
§Ú·Q»¡¤@­Ó¤@­Ó¹ïÀ³¦n¤F~¥i¬Oªø«×¤S«ÜÅå¤H~½Ð°Ý¬O§_¦³¤ñ¸û²©öªº¤èªk©O?

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-9-13 17:48 ½s¿è

¦^´_ 3# av8d

³o­n¬Ý§Aªº¤é´Á¿é¤J¬O«ç¼Ëªí¥Ü
¦AªÌ¸ó¦~«×®É§A¤S¸Ó¦p¦ó?
¥ý¤£¦Ò¼{¸ó¦~«×
G2=IF(ISERROR(FIND("¬¡°Ê",$D2))+(ISNUMBER(FIND("¬¡°Ê",$D2))*(--TEXT(C2,"00!:00")>0.5)),--TEXT(B2,"2011!/##!/##"),--TEXT(B2,"2011!/##!/##")-1)
®æ¦¡§ï¬°¤é´Á
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2011-9-14 09:19 ½s¿è

¦^´_ 4# Hsieh


    ¤j¤j±z¦n~¦pªG§Ú¦bKÄæ¤S·s¼W¤@­Ó§PÂ_¸Ó¦p¦ó§ï¼g©O?(¦p¤U)

§¹¦¨¤F~¤£ª¾¹D¹ï¤£¹ï(¦p¤U)
=IF(B6="","",IF($K6="®ð²y",--TEXT(B6,"2011!/##!/##")-5,IF(ISERROR(FIND("¬¡°Ê",$D6))+(ISNUMBER(FIND("¬¡°Ê",$D6))*(--TEXT(C6,"00!:00")>0.49)),--TEXT(B6,"2011!/##!/##"),--TEXT(B6,"2011!/##!/##")-1)))

ÁÂÁÂH¤j¤j~

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD