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

[µo°Ý] ½Ð±Ðexcel¤@­Ó¤p°ÝÃD ¦h­«§PÂ_°ÝÃD ¥X®u¤Ñ¼Æ

[µo°Ý] ½Ð±Ðexcel¤@­Ó¤p°ÝÃD ¦h­«§PÂ_°ÝÃD ¥X®u¤Ñ¼Æ

1414.jpg
2016-1-28 22:44




½Ð±Ð¤j¤j

¥[»²§UÄæ(³]¦bNÄæ)
N2¤½¦¡=WEEKDAY(D2,2), ¦V¤U©Ô
°²³]¬P´Á¤»,¤éºâ¥[¯Z, «h¥Î¤áC¥[¯Z¤é¼Æ
=COUNTIF(N2:N17,">5")/2

TOP

¦^´_ 2# yen956


   ec1.rar (10.41 KB)

TOP

¦^´_ 2# yen956


   ½Ð±Ð¤j¤j³o­Ó ¦pªG¤@¤Ñ­n¥´¥|¦¸¥d ¯à§PÂ_¤W¯Z§¹¾ã¤@¤Ñ?    ¥X²{¥´¨â¦¸¥d¤W¤È¤@¦¸¤U¤È¤@¦¸´N·|¥X²{­È¯Z?   ¤§«á¹J¨ì¥u¥´¨â¦¸ 0800¤U¯Z ¸ò1200¤U¯Z  «h¬°¤W¯Z¥b¤Ñ  «ö·Ó§ÚªºÀÉ®× ¤Wªº¤½¦¡ ­n¦b·s¼W¬Æ»ò?

TOP

¦^´_ 4# keovin790916

§Aªº½d¨ÒÀÉ¥u¦³­ì©l¥´¥d¸ê®Æ¡A
½Ð¸É¥R§A«á­pºâµ²ªGªº¼Ë¤l¡A¤j®a¤ñ¤F¸Ñ·Q­n¬Æ»ò?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089


    ½Ð±Ð¤j¤j  §Ú½d¨Ò¤j·§¬O³o¼Ë     Áٻݭn­þ­Ó¨ç¼Æ¤~¥i¥H°µ¨ì§¹¾ã  ·P®¦

ec1ok.rar (13.83 KB)

TOP

¦^´_ 6# keovin790916

¤W¯Z®É¼Æ
O2 =IF(D2=D1,"",LOOKUP(24*SUMPRODUCT((D2=D3:D5)*(TEXT(F3:F5,"[<>];;0;!0")-TEXT(F2:F4,"[<>];;0;!0"))*{1;0;1}),{0,4,8},{0,4,8}))
¤U©Ô

¥X®u¤Ñ¼Æ : Á`¤W¯Z®É¼Æ / 8
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089

·PÁ ¤j¤j ¥ß§Y¸Ñµª§Úªº°ÝÃD ¡C

½Ð±Ð¤@¤U  ­È¯ZÅã¥Ü¸ò¥[¯Z0.5   »Ý­n¥Î¨ì­þºØ¨ç¼Æ§PÂ_

TOP

¦^´_ 8# keovin790916

M2 =IF(D2=D1,"",IF(COUNTIF(D2:D5,D2)=2,"­È¯Z",""))

¥[¯Z®É¼Æ¬Ý¤£¥X¨Ó§A«ç»òºâªº¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089

­ì¨Ó¥i¥H³o¼Ë°µ   ¤j¤j¯u¼F®`

    ¥[¯Z®É¼Æ ´N¬O   7:30 ¤W¯Z  ¨ì¼Ð·Ç¤W¯Z®É¶¡08:00   ³o¼Ëµ¥©ó¥[¯Z30¤À   ºâ°µ0.5

°²³]   7ÂI¤W¯Z ¨ì   08:00    ³o¼Ë´N¬O1¤p®É¥[¯Z

³o¼Ë »Ý­n¥Î¨ì¬Æ»ò¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD