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

®É¶¡®æ¦¡

®É¶¡®æ¦¡

½Ð±Ð¦U¦ì¦p¦ó±N"®É¶¡(1)"¸Ìªº®É¶¡¥H¨ç¼Æ¤è¦¡¼g¦¨"®É¶¡(2)"®æ¦¡?
®É¶¡.jpg

®É¶¡.rar (6.58 KB)

¥»©«³Ì«á¥Ñ quickfixer ©ó 2021-11-20 22:18 ½s¿è

¦^´_ 1# oak0723-1


    =IF(b2="","",SUBSTITUTE(TEXT(b2,"?0-00-00"),"-",":"))
¤£½T©w²Ä¤@­Ó0­n¤£­n¦³¡A¸É¤W¥t¤@­Ó
=IF(b2="","",SUBSTITUTE(TEXT(b2,"00-00-00"),"-",":"))

TOP

=IF(B2="","",TEXT(B2,"0!:00!:00"))
©Î
=IF(B2="","",TEXT(B2,"00!:00!:00"))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁ¦U¦ì
¦ý­Y­nª½±µ±N¥H¤Wµ²ªG®³¨Ó°µ¤j¤p¤ñ¸û¦ü¥G¤£ok
¨Ò¦p: 4:59:59<15:00:00
¨Ò¦p: 0:00:00<4:59:59

TOP

¦^´_ 4# oak0723-1


   
=IF(B2="","",--TEXT(B2,"0!:00!:00"))
©Î
=IF(B2="","",--TEXT(B2,"00!:00!:00"))

­n³]©wÀx¦s®æ®æ¦¡  hh:mm:ss
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥i¯à§Úªí¹F¤£²M·¡
§Úªº·N«ä¦pªþ¥ó
Image 9.jpg

®É¶¡®æ¦¡(¨ç¼Æ) - ½Æ»s.rar (64.37 KB)

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD