lucky12345

¦^´_  lucky12345

=IF(AND(A1>=TIME(8,45,0),A1
register313 µoªí©ó 2012-4-17 17:43

register313¤j ¥i¥H¤F ÁÂÁÂ
¤]ÁÂÁ¤j®a¼ö¤ßÀ°¦£......

c_c_lai

¦^´_ 9# register313
=IF(AND(A1>=TIME(8,45,0),A1<=TIME(13,31,0)),"¥æ©ö¤¤","°±¤î¥æ©ö") ¦n¹³¤]¤£ºÞ¥Î©O¡I
°²³]A1 ªº®É¶¡¬O 13:15 ³ºµM¬O "°±¤î¥æ©ö"¡C
¦]¬°§Ú¤£¤Ó·|À³¥Î Excel ªº¤º³¡¨ç¼Æ¡C §Ú¥uª¾¹D¨Ï¥Î VBA ªº»yªk¡A¦p¤U¤§·N´N¬O¤F¡C
If (Cells(1,1).Value >= TimeValue("08:45:00") AND Cells(1,1).Value <= TimeValue("13:31:00")) Then Cells(2,1).Value = "¥æ©ö¤¤" Else Cells(2,1).Value = "°±¤î¥æ©ö"

¦^´_ 10# ajagow
©Ôª@¤O   = ²Ö­p½æ¦¨µ§ / ²Ö­p½æ¦¨µ§
¥D¤O¤¶¤J = Á`©e¶R¶q - Á`©e½æ¶q
´²¤á¤è¦V = Á`©e¶Rµ§ - Á`©e½æµ§
¶R¤è¤O¹D = Á`©e¶R¶q / Á`©e¶Rµ§
½æ¤è¤O¹D = Á`©e½æ¶q / Á`©e½æµ§
¦h®ø¤Æ¤ñ = ¦¨¥æ¶q / Á`©e¶R¶q
ªÅ®ø¤Æ¤ñ = ¦¨¥æ¶q / Á`©e½æ¶q

ÁA¸Ñ¹L¦h·|¤£®ø¤ÆËç¡I

c_c_lai

¦^´_ 11# lucky12345
¦^´_ 9# register313
¸g´ú¸Õµ²ªG¡A¥H¤U¤½¦¡¤~²Å¦X³]©w¤§±ø¥ó¡G

=IF(OR(A1<TIME(8,45,0),A1>TIME(13,31,0)),"°±¤î¥æ©ö","¥æ©ö¤¤...")

A1 = "8:44:59"     -> °±¤î¥æ©ö
A1 = "8:45:00"     -> ¥æ©ö¤¤...
A1 = "13:31:00"  -> ¥æ©ö¤¤...
A1 = "13:31:01"  -> °±¤î¥æ©ö

±ß¦w¡I

register313

¦^´_ 13# c_c_lai

=IF(AND(A1>=TIME(8,45,0),A1<=TIME(13,31,0)),"¥æ©ö¤¤","°±¤î¥æ©ö")
»P
=IF(OR(A1<TIME(8,45,0),A1>TIME(13,31,0)),"°±¤î¥æ©ö","¥æ©ö¤¤...")
¥\¯à¬O¤@¼Ëªº

c_c_lai

¦^´_ 14# register313
¨S¿ù¡I
¬Q¤Ñ¤@¶}©l§Ú¬O¨Ï¥Î =YT|KS!TXFD2.123 ¶×¤J¤§®É¶¡ (Ä´¦p¡G ¥Ø«e¬O 91938  -> 9:19:38 ¤§·N) ¨Ó°µ§PÂ_¡A
­ì¥»¥H¬°¥¦¬O®É¶¡Äæ©Ò¥H©¿²¤¤F¦Ó¥h°µ¤F¤ñ¹ï´ú¸Õ¡A«á¨Ó¤~§ï¥H¥t¥~ªº®É¶¡Äæ¦ì¤ñ¹ï (OR)¡A
­è­è¸Õ¹Lªº½T¦p register313 «e½ú©Ò¨¥ OK ªº (AND)¡I
ÁÂÁ«ü¾É¡I
¨º¥t¥~½Ð±Ð§Ú­n«ç»ò§â¤ñ¹ï¤§¦Û°Ê¶×¤JÄæ¦ì (91938) ¦Û°ÊÂন®É¶¡Äæ¦ì©O¡H ·PÁ±z¡I

register313

¦^´_ 15# c_c_lai

=TIME(LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2),RIGHT(A1,2))
®æ¦¡/Àx¦s®æ  ¦Û­q hh:mm:ss
©Î
=--TEXT(A1,"00\:00\:00")
®æ¦¡/Àx¦s®æ  ¦Û­q hh:mm:ss

c_c_lai

¦^´_ 16# register313
¦n¹³¥u¦¹¤@³~¡A§OµL¥Lªk¡C
§Ú­ì¥»·Q±N¸Ó¶×¤JÄæ­×§ïÀx¦s®æ®æ¦¡ -> ®É¶¡¡Aµ²ªG«oÅܦ¨ 00:00¡C
ÁÂÁ«e½ú«ü¾É¡I