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

[µo°Ý] ¤@­Ó¼Æ­ÈÂà´«ªº°ÝÃD

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

TOP

¦^´_ 12# ML089


ML¤j¹ê¦b¤Ó¯«¤F¡I

TOP

¦^´_ 12# ML089


     @.@ ¯uªº¬O¤Ó¯«¤F~~¤£¹L§Ú¸ÕµÛ¥´¥t¤@¦æ¸Õ¸Õ®É¡A¦n¹³¥L¤S¤£¦æ¤F..¦n¹³¥Lªº®æ¦¡¦³¤£¤@¼Ë¡A§Ú¸Ó¦p¦ó­×§ï@@???

¼Æ­ÈÂà´«1.rar (5.17 KB)

¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 14# inhogold


   ¦]¬°§ADÄ檺Àx¦s®æ®æ¦¡¬O¦Û­qªº[h]:mm¡A©Ò¥H§ïÅܤF­ì¨Ó¤½¦¡À³¸Ó­n§e²{¥Xªº­±»ª¡A
   §â¥L§ï¦^³q¥Î®æ¦¡©Î¼Æ­È´N¦æ¤F¡C

TOP

¦^´_ 14# inhogold


   
=TEXT(A1,"[h]")
¬°¤å¦r®æ¦¡¡A¤£¨üÀx¦s®æ®æ¦¡¼vÅT¡A¾A¦XÅã¥Ü¦C¦L¡A­Y»Ý«áÄò³B²z¼Æ­È¹Bºâ¤ñ¸û³Â·Ð¡C
¨Ò¦p­n²Î­p¡A¥Î SUM(A1:A9) µLªk§¹¦¨¡A»Ý¥Î SUM(--A1:A9) °}¦C¤½¦¡³B²z¡A¹ïªì¾ÇªÌ¤£«Øij¨Ï¥Î¡C


=--TEXT(A1,"[h]")
¬°¼Æ­È¡A·|¨üÀx¦s®æ®æ¦¡¼vÅT¡A¸Ô15¼Ó owen06 ¤jªº»¡©ú
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD