ANGELA

½Ð¤W¶ÇcxcelÀÉ,¨Ã¸Ô²Ó»¡©ú»Ý¨D¤ÎÁ|¨Ò.

ANGELA

¦^´_ 5# wilsontw


    EXCELÀÉ­n¥ýÀ£ÁY¦¨ZIP©ÎRAR¦A¤W¶Ç
      ­n§A¤W¶ÇÀɮ׬O¸`¬Ù¤j®a®É¶¡,¨Ì§Aªº¹Ï¤ù°µ¥X¨ÓªºÀÉ®×¥i¯à¤£²Å¦X§Aªº»Ý¨D,ÁÙ­n²q§Aªº¥Øªº,ÁÙ¬O½Ð§A¾Ç¾Ç§a.

ANGELA

¥Î¥¿³Wªº®É¶¡®æ¦¡f3= 2011/5/1  14:00:00
Àx¦s®æ®æ¦¡ -> ®É¶¡  -> 1:30 pm    ·|Åã¥Ü¦¨ 2:00 pm
h3=(G3-F3)*24  ©¹¤UCOPY
f13=SUMIF(INDIRECT(CHAR(65+ROW(A1))&"3:"&CHAR(65+ROW(A1))&10),"V",$H$3:$H$10)

ANGELA

¤£¬O­n§A§ï¦¨¥¿³W§t¤é´Áªº®É¶¡®æ¦¡¶Ü?
§t¤é´Á¤~ª¾¹D¬O§_¦³¸ó¤é.´î¥X¨Óªº­È¤~·|¥¿½T.
¥Î¥¿³Wªº®É¶¡®æ¦¡ f3= 2011/5/1  14:00:00Àx¦s®æ®æ¦¡ -> ®É¶¡  -> 1:30 pm    ·|Åã¥Ü¦¨ 2:00 pm

h3 Àx¦s®æ®æ¦¡¦Û­q  h:mm;@

ANGELA

¤U¸ü (106.92 KB)

2011-5-17 14:51

ANGELA

H14=SUMIF(INDIRECT(CHAR(65+ROW(B1))&"3:"&CHAR(65+ROW(B2))&10),"V",$H$3:$H$10)/SUM($H$3:$H$10)
18f ªº¹Ï¤ù¤¤¤£¬O¦³h14ªº¤½¦¡¶Ü? ¦P¤@¤½¦¡©¹¤UCOPY.

¶W¹L24¤p®É¥¦·|Åã¥Ü¬°1,48¤p®É¬°2 ,¤p¼Æ§Y¬O®É¤Î¤À,¨Ã¤£·|Âk¹sªº

ANGELA

SUM($H$3:$H$11)=3.78472222221899
3.78472222221899 = 3¤Ñ18¤p®É50¤À
3.78472222221899 *24  =90.8333333332558 §Y¬O¤p®É¼Æ
72¤p®É= ¤T¤Ñ
90.8333333332558 -72   =18.8333333332558  ³Ñ¾l®É¼Æ §Y18¤p®É,¤p¼Æ§Y¬O¤À
0.833333333*60 = 50¤À

¥ÎH3ªº®æ¦¡¨ê¤@¤U§Y·|Åã¥Ü18:50,¦ý¤£·|Åã¥Ü´X¤é