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

52ee24

½Ð°Ý¦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

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

52ee24

¦^´_ 2# p212


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

ML089

¦^´_ 1# 52ee24

B2 =LOOKUP(MOD(A2,1),--{0,"7:40","19:41"},{"©]","¤é","©]"})&"¯Z"
¤U©Ô

p212

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

JBY

B2 :

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

ML089

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

52ee24

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

JBY

¦^´_ 7# ML089

¨Ï¥Î IF ¨ç¼Æ :

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

ML089

¦^´_ 9# JBY

¦n·Qªk¡ÐÆg