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

®É¶¡´«ºâ

®É¶¡´«ºâ

½Ð°Ý¦bA2Àx¦s®æ¿é¤J 1'25"32 (½Xªí®É¶¡), ¦p¦ó¦bA2Àx¦s®æÅã¥Ü85"32 (85¬í32²@¬í)

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-20 13:52 ½s¿è

¦^´_ 1# 074063
Excel·|±N¡u"""¡v»{©w¬O¿ùªº
©Ò¥H¥ÎCHAR(34)´À´«²Å¸¹¡u"""¡v( CHAR(34)=¡u"¡v)
=(LEFT(A1,FIND("'",A1)-1)*60+MID(A1,FIND("'",A1)+1,FIND(CHAR(34),A1)-FIND("'",A1)-1))&CHAR(34)&RIGHT(A1,LEN(A1)-FIND(CHAR(34),A1))
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# 074063
  1. 1'25"32 ¤£¬O EXCEL ®É¶¡®æ¦¡¡A·|³Qµø¬°¤å¦r¡A¨S¦³¿ìªk©óA2¥Î®æ¦¡¨Ó³B²z¡A»Ý­n©óB2¤½¦¡³B²z

  2. EXCEL ®æ¦¡¬°  00:01:25.32  ®æ¦¡³]¬° [s]!".00
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ JBY ©ó 2015-8-20 17:49 ½s¿è

B2 ¤½¦¡:

=REPLACE(A1,1,FIND("""",A1)-1,("0:"&LEFT(SUBSTITUTE(A1,"'",":"),FIND("""",A1)-1))*86400)

TOP

http://blog.xuite.net/hcm19522/twblog/352344536
¤è¦¡¤@=INT(SUBSTITUTE(SUBSTITUTE(B2,"""",":"),"'",":")*1440)&MID(B2,FIND("""",B2),9)
¤è¦¡¤G=INT(SUBSTITUTE(LEFT(B2,FIND("""",B2)-1),"'",":")*1440)&MID(B2,FIND("""",B2),9)

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD