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

[µo°Ý] ¤u®É²Î­p

[µo°Ý] ¤u®É²Î­p

½Ð±Ð¤@¤U¤u®É²Î­p:

·Q¥Hªí¦Cªº§Î¦¡¦C¥X¨C¤@­Ó­û¤u¨C¤ëªº¤u®É¬O¦h¤Ö? ©M¦Û°Ê­pºâStaff 1 ¦ÜStaff4ªº¤u®É¬O¦h¤Ö (¶À¦â­þ4¦æ)?

¦ýÀɤº¬O¥H0830¥Nªí(8:30), 3100¥Nªí(24:00+ 7hrs).  ¦Ó¥B­û¤u¤@Äæ¤]¤£¬O¥þ¶ñ¤Wªº, ¥i¥H«ç¼Ë°µ©O?

HR-count1.rar (7.23 KB)

¤u®É²Î­p

¦^´_ 1# xmi

¥Î¨ç¼Æ
I2=IF(E2="",0,(LEFT($C2,LEN($C2)-2)*60+RIGHT($C2,2)-LEFT($B2,LEN($B2)-2)*60-RIGHT($B2,2))/60)
O2=SUMPRODUCT((MONTH($A$2:$A$17)=O$1)*($E$2:$H$17=$N2)*($I$2:$L$17))

HR-count1.rar (9.49 KB)

TOP

¦^´_  xmi

¥Î¨ç¼Æ
I2=IF(E2="",0,(LEFT($C2,LEN($C2)-2)*60+RIGHT($C2,2)-LEFT($B2,LEN($B2)-2)*60-RI ...
register313 µoªí©ó 2012-1-20 00:03


register313: ¤£¦n·N«ä§r, §Ú¨S¦³Åv­­¤U¸ü:Q ..  ¥i¥H«ç¼Ë¬Ý§r??:'(

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD