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

¦p¦ó§ì¨ú(®É¶¡)¥æ©ö®É¬q

¦p¦ó§ì¨ú(®É¶¡)¥æ©ö®É¬q

a1=23:00:01(a1¥¦¬ODDE³sµ²¨÷°Ó¥­¥x)¨C¬íÀH®É¸õ°Ê¤@¦¸
§Úªº»Ý¨D¦p¤U........
a2=if(a1=¤µ±ß23:00:00¨ì©ú¦­06:00:00,"¥æ©ö¤¤","°±¤î¥æ©ö")
½Ð¨D¦U¦ì¤j¤jªºÀ°¦£...ÁÂÁ±z
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

¦^´_ 1# lucky12345


=IF(OR(HOUR(A1)>=23,HOUR(A1)<6),"¥æ©ö¤¤","°±¤î¥æ©ö")

TOP

¦^´_ 2# register313

¥i¥H¥Î¤F
ÁÂÁ±zªº«ü¾É.......
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

a1=10:00:01(a1¥¦¬ODDE³sµ²¨÷°Ó¥­¥x)¨C¬íÀH®É¸õ°Ê¤@¦¸
§Úªº»Ý¨D¦p¤U........
a2=if(a1=¦­¤W08:45:00¨ì¤¤¤È13:31:00,"¥æ©ö¤¤","°±¤î¥æ©ö")
½Ð°Ý¦U¦ì¤j¤j¤SÀ³¦p¦ó¡H   ÁÂÁ«ü¾É
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 4# lucky12345
¦p¦P register313 ©Ò¨¥¡G
°²³]¡G AD5="08:45:00" ¡AAD6="13:45:00"
=IF(OR(HOUR(A1)>=AD5,HOUR(A1)<AD6),"¥æ©ö¤¤","°±¤î¥æ©ö")
´N OK ¤F¡I

TOP

¥»©«³Ì«á¥Ñ lucky12345 ©ó 2012-4-17 12:30 ½s¿è
¦^´_  lucky12345
¦p¦P register313 ©Ò¨¥¡G
°²³]¡G AD5="08:45:00" ¡AAD6="13:45:00"
=IF(OR(HOUR(A1)> ...
c_c_lai µoªí©ó 2012-4-17 11:46



    ÁÂÁ¤j¤j.......
¥i¬O¤£¦æ£z£°
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 6# lucky12345
§Ú¥H¹ê»Ú¹B§@ªº¸ê®Æ¡A¥H¤Î¦UÄæ¦ì¦p¦ó³]©w¤º®e¡A¥H¹Ï¥ÜÅý§A¤F¸Ñ¡C

01.png
2012-4-17 12:30

TOP

ÁÂÁ¤j¤j¥Î¤ß«ü¾É
¥i±¤¤pªº·M¬N.........¤@®É§Ë¤£¨Ó
¦b¬ù©w®É间¤º ="¥æ©ö¤¤"µL»~
¥i¬O¶W¥X®É¥~ ÁÙ¬Oµ¥©ó"¥æ©ö¤¤"
¶Ì²´.....xd
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 8# lucky12345

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

TOP

¦^´_  lucky12345
§Ú¥H¹ê»Ú¹B§@ªº¸ê®Æ¡A¥H¤Î¦UÄæ¦ì¦p¦ó³]©w¤º®e¡A¥H¹Ï¥ÜÅý§A¤F¸Ñ¡C
c_c_lai µoªí©ó 2012-4-17 12:30



½Ð°ÝC C LAI¤j¤j   ©Ôª@¤O¡B¥D¤O¤¶¤J¡B´²¤á¤è¦V¡B¶R¤è¤O¹D¡B½æ¤è¤O¹D¡B¦h®ø¤Æ¤ñ¡B«ç»ò­pê¿¥X¨Óªº
ÁÂÁÂ
¯qÁ¨à

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD