GBKEE

¦^´_ 1# app4000
VBA
Format(Application.SumIf(Range("A1:A10"), "YES", Range("B2")), "HH:MM:SS")
¤u§@ªí
TEXT(SUMIF(A1:A10,"YES",B2),"HH:MM:SS")

GBKEE

¦^´_ 3# app4000
VBA
Format(Application.SumIf(Range("A1:A10"), "YES", Range("B2")), "M/D HH:MM:SS")
¤u§@ªí
TEXT(SUMIF(A1:A10,"YES",B2),"M/D HH:MM:SS")

GBKEE

¦^´_ 5# app4000
¨S¿ù£«¬O 1:20:30:00

GBKEE

¦^´_ 9# PD961A
¤@¼Ë°Ú,¨º¸Ì¤£¤@¼Ë?? §Ú¨S¬Ý¥X¨Ó!

GBKEE

¦^´_ 11# PD961A
TEXT(SUMIF(A1:A10,"YY",B1),"M/D HH:MM:SS")=TEXT(SUMIF(A1:A10,"YY",B1:B10),"M/D HH:MM:SS")

GBKEE

¦^´_ 13# PD961A
¹ï¤£°_  ¨S±M¤ß¨S¬Ý¨ì¦³ªþÀÉ,©Ò¥H¤@ª½¨S»¡¨ì­«ÂI ÁÙ¯uªº¥H¬°©p»¡§A«Ü²Âªº.
©JÀɪºA1:A10ªº¦r¤¸ §A¬Oºô¤W§ì¤U¨Óªº"YES     "¦³¤£¥i¨£¦r¤¸  ­n§R±¼ ­«keyIn  "YES"   
³o¸Ì¤]­n§ï
TEXT(SUMIF(A1:A10,"YES",B1),"M/D HH:MM:SS")=TEXT(SUMIF(A1:A10,"YES",B1:B10),"M/D HH:MM:SS")

GBKEE

¦^´_ 17# PD961A
¿ù¦b A1:A10 ¤¤ªº"YES"<>¤½¦¡¤¤ªº"YES"   
½Ð¦bD2 ¥´¤W "YES"
½Ð¦bD3 ¥´¤W ¤½¦¡ =A2=D2  ±o¨ì FALSE  ªí¥Ü ¨âªÌ¤å¦r¬O¤£¤@¼Ë
A1:A10 ªº¤å¦r¥þ³¡§R±¼ ­«·s¥´¤W´N¥¿±`¤F.
¤§«áHsieh ª©¥Dªº¤½¦¡´N¤£¤@¼Ë¤F
¦b³o¸Ì­n½Ð±ÐHsieh ª©¥D¤½¦¡¤¤"YES"¬O¦p¦ó»s¦¨ªº?

GBKEE

¦^´_ 19# Hsieh
ÁÂÁÂ!
§Úª¾¹D¬O½Æ»sªº,¦ý¥ý«e½Æ»s¤@©w­n"YES " ­n¦h¤@­ÓªÅ®æ.
»¡¤]©_©Ç¬Ý¨ì§Aªº¦^¤å ¦A¸Õ¸Õ½Æ»s«á´N¥¿±`.

GBKEE

¦^´_ 22# PD961A
¤£¥i¨£¦r¤¸ ¬O±qºô­¶¤Wª½±µ½Æ»s¸ê®Æ¤U¨Ó,¤£¥i¹w´Á©Ò²£¥Íªº.
A30 -  ©Î¥ÎÀx¦s®æ°Ñ·Ó§Y¥i      
A31 -  1/0 00:00:00        =TEXT(SUMIF(A2:A11,$A$1,B2:B11),"M/D HH:MM:SS")  ¬O2¤~¹ï
A32 -  1/1 11:50:00        ¥¦ªºµª®×¤]¤£¬O1¤Ñ11:50(³£¬O1/1 11:50)
¥¦ªº¤½¦¡  =TEXT(SUMIF(A2:A11,$A$2,B2:B11),"D HH:MM:SS")