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

[µo°Ý] Âà´«¦³®Ä®É¶¡Åã¥Ü

[µo°Ý] Âà´«¦³®Ä®É¶¡Åã¥Ü

¦U¦ì¤j¤j:
  
½Ð°Ý§Ú­n±N®É¶¡1.09.88  (¤@¤À,¹s¤E¬í,¤K¤K) Âà´«¦¨¦³®Ä®É¶¡,§ÚÀ³¥ÎÂI¼g©O??

ÁÂÁÂ

¦^´_ 1# mdr0465
¦³®Ä®É¶¡ªº·N«ä¬O¤°»ò?
¬O­nÂà´«¦¨¦¹®É¶¡ªºµ¥­È¼Æ¦r¥H¥Î©ó­pºâ¦¡¤¤¶Ü?
­Yª½±µ½á­Èµ¹Àx¦s®æ -  #00:01:09.88# »P 00:01:09.88 ¨t²Î³£¤£±µ¨ü.
­Y¥Î TimeSerial ¨ç¼Æ,«h¬í¼Æ³¡¤À·|¦Û°ÊÅܦ¨¾ã¼Æ ->¤£¦X§Aªº»Ý¨D
­Y¥Î  TimeValue ¨ç¼Æ,«h¬í¼Æ³¡¤À¤£±µ¨ü¤p¼Æ -> ¤@¼Ë¤£¦X§Aªº»Ý¨D
°ò©ó¥H¤W­ì¦]¥Îµ{¦¡½á­Èªº¤è¦¡§ÚÁÙ¨S§ä¥X¤èªk.

­Y¥u¬O­n¦bÀx¦s®æÅã¥Ü¦p¦¹¼Ë¦¡ªºµ²ªG,
¥Ø«e¥u¸Õ¥X¨Óª½±µ¿é¤J¨ìÀx¦s®æ¥i¥HÅã¥Ü¥X¦¹µ²ªG,
¬ÛÃö³]©w½Ð°Ñ¦Ò¤U¹Ï:
¤@¤À¹s¤E¬í¤K¤K.jpg
2016-3-8 23:13

TOP

©ú¥Õ¤F,
ÁÂÁÂluhpro

TOP

¦^´_ 1# mdr0465

A1 ¬° "1.09.88"

[B1] = Application.Substitute([A1], ".", ":", 1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD