§ó§ï¹Lªº®æ¦¡¦p¦óÅý¥L¥[Á`?(Hsieh¤j¤j¸Ñ¨M¤F§ÚªººÃ´b¡AÁÂÁ§A)
- ©«¤l
- 703
- ¥DÃD
- 276
- ºëµØ
- 0
- ¿n¤À
- 1005
- ÂI¦W
- 1
- §@·~¨t²Î
- Windows 10
- ³nÅ骩¥»
- Office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-29
|
§ó§ï¹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¨ÓÆ[¬Ý¤å³¹¡AY¬OÁÙ¦³¤°»ò¬Ý¤£À´±o¡AÅwªï´£¥X¡A¦A¦¸·PÁ¦U¦ì¸ê²`¤j¤jªºÃö·Ó¡I |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 246
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 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°Ý
|
|
|
|
|
- ©«¤l
- 703
- ¥DÃD
- 276
- ºëµØ
- 0
- ¿n¤À
- 1005
- ÂI¦W
- 1
- §@·~¨t²Î
- Windows 10
- ³nÅ骩¥»
- Office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-29
|
¦^´_ 2# Hsieh
¤£¦n·N«ä~¦A¦¸¥´ÂZ~¥Ñ©ó§Úªº¸ê®Æ¬O¤é´Á®æ¦¡~©Ò¥H¨C¦¸¦b¨C¤ë1¤éªº®ÉÔ³£·|¥X²{¿ù»~~
§Ú·Q»¡¤@Ó¤@Ó¹ïÀ³¦n¤F~¥i¬Oªø«×¤S«ÜÅå¤H~½Ð°Ý¬O§_¦³¤ñ¸û²©öªº¤èªk©O? |
|
|
|
|
|
|
- ©«¤l
- 703
- ¥DÃD
- 276
- ºëµØ
- 0
- ¿n¤À
- 1005
- ÂI¦W
- 1
- §@·~¨t²Î
- Windows 10
- ³nÅ骩¥»
- Office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-29
|
¥»©«³Ì«á¥Ñ 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~ |
|
|
|
|
|
|