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

«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ

«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ

Dear all,
§Ú·Q¦bÀx¦s®æ¤º³]©w(±ø¥ó¦¡®æ¦¡³]©w)¡G·í¸ÓÄæ¦ì¤H¤u¿é¤J¸ê®Æ®É¨Ã«D¬O¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ
½Ð°Ý­n«ç»ò³]©w¡H¨Ï¥Î­þ¤@¨ç¼Æ©O¡H
ÁÂÁ¡I

¶À¦â©³³¡¤À¡A§Ú§Æ±æ¬O«D®É¶¡®æ¦¡®É¡A¥¦·|¦Û°ÊÅܦâ




«D¼Ð·Ç®É¶¡®æ¦¡¡A¸ÓÀx¦s®æ¦Û°ÊÅܦâ.rar (7.43 KB)
Just do it.

¦^´_ 14# ML089

Hi ·PÁ±zªº¦^À³¡A
§Ú¤£¬O«ÜÀ´±z©Ò»¡ªº·N«ä¡A¬O§_¥i¥H¦³½d¨Ò¬Ý©O¡H
·P®¦·P®¦¡I
Just do it.

TOP

CELL("format",A2) ¥u¬O°»´ú¥Ø«eÀx¦s®æ®æ¦¡¤Æ±¡ªp¡A¸òÀx¦s®æ¤º®e¨S¦³Ãö«Y¡C
¨Ò¦p
A1 ³]¬° D9®æ¦¡¡A¦bA1¿é¤J ¤å¦r "ABC"¡A¿é¤J¼Æ¦r 123¡A¨Ï¥ÎCELL("format",A1) ³£·|±o¨ì "D9" ®æ¦¡

­Y¬O¡A­ì¦³¸ê®ÆªºÀˬd¡A"8:30" ¸ò 8:30 ³o¨â­Ó®É¶¡¬Ý°_¨Ó¬O¤@¼Ëªº®É¶¡¡A¦ý ¤@­Ó¬O¤å¦r¡A¥t¤@­Ó¬O¼Æ¦r¡A§A»{¬°2­Ó³£OK¡A©Î­n°Ï¤À¤£¤@¼Ë¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2021-4-29 10:58 ½s¿è

¦^´_ 6# jsc0518

®É¶¡¦bEXCEL¬O¤p©ó1ªº¤p¼Æ³¡¦ì
¤é´Á¦bEXCEL¬O¤j©ó1ªº¾ã¼Æ³¡¦ì
5.18 ³Q®É¶¡®æ¦¡¤Æ«á¥uÅã¥Ü¨ä¤¤ 0.18 ¬°®É¶¡ 4:19¡A¥t¥~¾ã¼Æ¬°¤é´Á 1911/1/5 (¨S¦³Åã¥Ü)

­Y§A­n±±¨î©Î§PÂ_¬O§_¿é¤J®É¶¡¡A
²Ä¤@­Ó§PÂ_¬° =A2<1¡A
²Ä¤G§PÂ_¬O§_®æ¦¡¤Æ¬°®É¶¡®æ¦¡  =CELL("format",A2)
"D7"¡Gh:mm AM/PM
"D6"¡Gh:mm:ss AM/PM
"D9"¡Gh:mm
"D8"¡Gh:mm:ss "D8"

«Øij©ó¸ê®Æ¿é¤J¡A©ó¸ê®ÆÅçÃÒ ­­¨î¥u¯à¿é¤J <1 ªº¤p¼Æ
­Y¬O­ì¦³¸ê®Æ¥H Àx¦s®æ®æ¦¡¤Æ¤è¦¡¨ÓÀˬd®É¡AA2®æ¦¡¤Æ¤½¦¡ ¿é¤J =TEXT(A2,"[<=1]!0;!1;!1;!1")/1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# samwang


¦A³Â·Ð¤j®a¡A¬O§_¦³¨ä¥L¤èªk¥i¥H§JªA©O¡H
Thank you.
Just do it.

TOP

¦^´_ 10# hcm19522


·PÁÂh¤j¤j¦^ÂСA¤½¦¡ºë²¦³¤O¡A¾Ç²ß¤F¡C

¥t¥~¡A½Ð±Ð¦b#7¼Óªº¨º­Ó°ÝÃD¦³¸Ñ¶Ü? ¦n¹³Àx¦s®æ®æ¦¡...¡AÁÂÁ¡C

TOP

=ISERR(A2*1)+(A2>1)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

½Ð±Ð¤@¤U¦U¦ì¤j¤j¡A°w¹ï³oÃD°ÝÃD¦³¦ó¬Ýªk©Î¸Ñªk?? ·PÁÂ

TOP

¥»©«³Ì«á¥Ñ samwang ©ó 2021-4-22 14:01 ½s¿è

¦^´_ 6# jsc0518

¦pªG§âAÄæ³]¬°³q¥Î®æ¦¡¡A²Ä¤@¦¸¿é¤J¬°¤é´Á®æ¦¡¡A¸ÓÀx¦s®æ´N·|³]¬°®É¶¡®æ¦¡¡A
¦p¤S¿é¤J5.18¡A«h´N·|µø¬°¼Æ¦r®æ¦¡±j¨î§ï¬°®É¶¡®æ¦¡
§Ú¦Û¤v¤]ı±o«Ü©_©Ç¡A
³o¥i¯à­n½Ð¨ä¥L¤j¤j¨Ó¸Ñ´b¤F
ÁÂÁ¡C

TOP

¦^´_  samwang


  µo²{¤@°ÝÃD¡A¿é¤J5.18¡A¥¦·|Åܦ¨®É¶¡
jsc0518 µoªí©ó 2021-4-22 13:41



µo²{¨ä¥L°ÝÃD

ERROR.gif
Just do it.

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD