- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-30 10:44 ½s¿è
¦^´_ 1# jaga0828
´£¨Ñ¥t¤@ºØ¨ç¼Æ¸Ñªk
1¡B©w¸q¦WºÙ¡u¯Z§O¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J
=SUMPRODUCT((VALUE(TEXT(¤u§@ªí1!$A2,"hh:mm"))>VALUE("7:30"))*(VALUE(TEXT(¤u§@ªí1!$A2,"hh:mm"))<VALUE("19:31")))+1
2¡BÀx¦s®æB2¿é¤J¤½¦¡
=IFERROR(IF(VALUE(TEXT(A2,"hh:mm"))>VALUE("7:30"),TEXT(LEFT(A2,8),"mm/dd")&CHOOSE(¯Z§O,"©]¯Z","¤é¯Z"),TEXT(DATEVALUE(TEXT(LEFT(A2,8),"mm/dd"))-1,"mm/dd")&CHOOSE(¯Z§O,"©]¯Z","¤é¯Z")),"")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I |
-
-
fig.jpg
(81.25 KB)
|