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

[µo°Ý] ½Ð°Ý­n¦³¤°¨ç¼Æ¥i¥H§PÂ_®É¶¡¨Ó¤À¥X¤é¡B©]¯Z

[µo°Ý] ½Ð°Ý­n¦³¤°¨ç¼Æ¥i¥H§PÂ_®É¶¡¨Ó¤À¥X¤é¡B©]¯Z

¥»©«³Ì«á¥Ñ 52ee24 ©ó 2015-8-20 13:44 ½s¿è

½Ð°Ý¦U¦ì¥ý¶i
¤½¥qªº¤W¯Z®É¶¡¬O0740~1940¤é¯Z1940~0740©]¯Z
§Ú¥i¥H¥Î¤°»ò¨ç¼Æ¨Ó§PÂ_¡Aµ²ªG¦bBÄæ¼g¤U¬O¤é©Î©]¯Z
³Â·Ð¦U¦ìÀ°À°¦£¤F
ÁÂÁÂ

AÄæ                                  BÄæ
log off ®É¶¡        ¤é/©]¯Z
2015/8/1 16:42       
2015/8/1 16:42       
2015/8/1 16:42       
2015/8/1 16:42       
2015/8/1 16:42       
2015/8/1 16:42       
2015/8/2 04:49       
2015/8/2 04:49       
2015/8/2 04:49       
2015/8/2 04:49       
2015/8/2 04:49       
2015/8/2 04:49       
2015/8/2 16:51

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-20 14:39 ½s¿è

¦^´_ 1# 52ee24
¦p1#¤§A橺¸ê®Æ¦ÛÀx¦s®æA2¶}©l
Àx¦s®æB2¿é¤J
=IF((TIMEVALUE(TEXT(A2,"hh:mm:ss"))>=TIME(7,40,))*(TIMEVALUE(TEXT(A2,"hh:mm:ss"))<TIME(19,40,)),"¤é¯Z","©]¯Z")
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212


    ÁÂÁÂp¤j
¤Ó±j¤F~
ÁÂÁ§Aªº«ü¾É

TOP

¦^´_ 1# 52ee24

B2 =LOOKUP(MOD(A2,1),--{0,"7:40","19:41"},{"©]","¤é","©]"})&"¯Z"
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089
«Ü§®ªº´À¥N IF ¨ç¼Æ¸Ñªk¡A¨ü±Ð¤F¡C
·PÁÂML089ª©¤j«ü¾É¡I

TOP

B2 :

=TEXT(MOD(A2,1),"[>=0.82]©]¯Z;[>0.3194]¤é¯Z;©]¯Z")

TOP

¦^´_ 5# p212

¥D­n¬O¨Ï¥ÎMOD¨ç¼Æ¨ú¥X®É¶¡
  1. =IF((MOD(A2,1)>--"7:40")*(MOD(A2,1)<=--"19:40"),"¤é¯Z","©]¯Z")
  2. =IF((MOD(A2,1)>TIME(7,40,))*(MOD(A2,1)<=time(19,40,)),"¤é¯Z","©]¯Z")
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

§A­Ì³£¤Ó±j¤j¤F
ÁÂÁ§A­Ìªº«ü¾É
¤p§Ì¨ü±Ð¤F

TOP

¦^´_ 7# ML089

¨Ï¥Î IF ¨ç¼Æ :

=IF(-(ABS(MOD(A1,1)-0.569)<0.25),"¤é¯Z","©]¯Z")

TOP

¦^´_ 9# JBY

¦n·Qªk¡ÐÆg
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD