[µo°Ý] ¨D²[¼Æ³]­p¸Ñµª¡G¥´¥d°O¿ý¦Û°Ê±Æ¦C­pºâ¿ð¨ì¦­°h¯Ê¶Ô¡K ¦Ò¶Ô, ¥´¥d

newlink

§Ú¤½¥q¥Î«ü¯¾¾÷¥´¥d¡A¨C­Ó¤ë¤U¸ü¥´¥d°O¿ý¡A¥u¦³­û¤u½s¸¹©M¤W¯Z¡B¤W¯Z®É¶¡¡A
¨C¦¸³£­nªá«Ü¦h®É¶¡±Æ¦C­«²Õ¡A­pºâ¦n¿ð¨ì¡B¦­°h´X¤ÀÄÁ¡A«Üªá®É¶¡
§Ú§â»Ý¨D©ñ¦bªþ¥ó¤W¡A§Æ±æ¦³°ª¤âÀ°§Ú¸Ñµª¡A§Ú¤]¥i¥H¾Ç²ß¤@¤U¡A·PÁ¡I

ML089

¦^´_ 6# newlink

TEXT(...) «e¥[ 1*
   

H24 =IF(F24="¥ð°²",0,1*TEXT(IFERROR(MOD(F24,1)-F$22,0),"[m];!0;!0"))
I24 =IF(F24="¥ð°²",0,1*TEXT(IFERROR(G$22-MOD(G24,1),0),"[m];!0;!0"))
J24 =IF(F24="¥ð°²",0,1*TEXT(IFERROR(MOD(G24,1),0)-G$22,"[m];!0;!0"))

°O±o¦³°ÝÃD»Ý¦b¸Ó¼Ó¦ì¸m¤U¤è«ö¦^ÂСA¨t²Î¤~·|³qª¾§Ú

newlink

J24¤]¤@¼Ë¡A¥[¯Z¤ÀÄÁ¼Æ¤£¯à¥[Á`

newlink

I24³oÄæ¨S¿ìªk¥[Á`«ç»ò¿ì¡H

ML089

¦^´_ 3# p212


    ¥¿;­t;¹s;¤å¦r

¥D­n±N­t­È¤Î¹sÂର  0¡A¥Î "[m];!0;0" ¤]¥i¥H

p212

¦^´_ 2# ML089
·Ð½ÐML089ª©¥D½ç±Ð¡AÁÂÁ¡I
¦b2#¤½¦¡  TEXT(IFERROR(MOD(F24,1)-F$22,0),"[m];!0;!0")
¬°¦óformat_text³]¬°"[m];!0;!0"¡A¦Ó¤£ª½±µ³]¬°"[m]"¡H

ML089

F24 =IFERROR(--TEXT(LOOKUP(G24-"1:00",B$2:B$143/(E$21=A$2:A$143)),"[>"&D24&"]"),"¥ð°²")

G24 =IFERROR(--TEXT(LOOKUP(D24+1+F$22-"1:00",B$2:B$143/(E$21=A$2:A$143)),"[>"&D24&"]"),"¥ð°²")

H24 =TEXT(IFERROR(MOD(F24,1)-F$22,0),"[m];!0;!0")

I24 =IF(F24="¥ð°²",0,TEXT(IFERROR(G$22-MOD(G24,1),0),"[m];!0;!0"))

J24 =IF(F24="¥ð°²",0,TEXT(IFERROR(MOD(G24,1),0)-G$22,"[m];!0;!0"))

¥ýµ¹§A¸Õ¸Õ¬Ý
¦³°ÝÃD¦Aµo°Ý¡A¬P´Á¤@¯S¦£¥i¯à¨S¦³¿ìªk¥ß§Y¦^ÂÐ