- ©«¤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¿ý
- 2025-1-2
  
|
¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-25 08:55 ½s¿è
¦^´_ 16# keovin790916
1¡B14#©Ò´£¡u·í¤Ñ¥u¥X¶Ô¤W¤È¤W¯Z ¤§«á¤U¤È¤U¯Zªº¡v(³sÄòȶԪÌ)¡A16#½d¨ÒÀɤ§KÄæÀ³¬O¥¿½Tªº¡C¦ÓHÄæ¦ìY±ý¦A¼Ðµù¡A«h«Øij¤½¦¡¬°
=CHOOSE(MATCH(TEXT(LOOKUP(,0/(MIN((G¸s²Õ-$F2)^2)=(G¸s²Õ-$F2)^2),G¸s²Õ),"hh:mm"),{"08:00";"12:00";"13:30";"17:00"},0),"ȯZ","","ȯZ","")
²£¥Í¡uȯZ¡vªºµ²ªG
2¡B16#½d¨ÒÀɪº¸ê®Æ¬Ò¬°È¶Ô¬ö¿ý¡A¬Gpºâ¡u¥X®u¤Ñ¼Æ¡v«Øij¤½¦¡¬°
=SUMPRODUCT(1/COUNTIF($D$2:$D$17,$D$2:$D$17))
3¡B16#½d¨ÒÀɪºG6Àx¦s®æ©Òz¡u·|¹J¨ì¦³¨â¤Ñ¥´¥dªº¡v¡A¬°¦ó¡H
4¡BYE2Àx¦s®æ¬°¤â°Ê¿é¤J¡A«h¥iÂÇ¿é¤J=TEXT(D2,"aaaa")¡A¦V¤U½Æ»s¤½¦¡¡A²£¥Í¡u¬P´ÁX¡vªºµ²ªG¡F©Î¿é¤J=TEXT(D2,"aaa")²£¥Í¡u¶gX¡vªºµ²ªG¡C
¥H¤W©å¨£¡A½Ð°Ñ¦Ò¡I |
|