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

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

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

§Ú¤½¥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

¥´¥d°O¿ý°ÝÃD.rar (12.89 KB)

robin

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¦^ÂÐ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 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

TOP

¦^´_ 3# p212


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

¥D­n±N­t­È¤Î¹sÂର  0¡A¥Î "[m];!0;0" ¤]¥i¥H
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

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

TOP

¦^´_ 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ª¾§Ú
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD