ML089

¦^´_ 1# fangsc


¤¤¤È12:00 - 13:00 ¤£¥Î¦©¶Ü?

ML089

¦^´_ 5# fangsc
   
> Row#7  5/27~6/4    :  32.0
> 5/28, 5/29, 5/30, 6/3 ¦@4¤Ñ¾ã (32¤p®É) + 5/27 15:50 (¤@¤p®É¤S¤Q¤ÀÄÁ) + 6/4 13:46  (¤­¤p®É¤S46¤ÀÄÁ) = 38¤p®É¤S56¤ÀÄÁ
> ¦]¬°ÁÙ¨S¬ÝÀ´¤½¦¡,©Ò¥HÁÙ¬O­n½Ð±Ð±z....

»¡©ú¦³»~¡AÃD¥Ø¬°¤@¤Ñ¤u§@®É¬q¬° 8:00~17:00 ¦X­p¨C¤Ñ¬°9¤p®É

©Ò¥HÀ³­×¥¿¬°
5/28, 5/29, 5/30, 6/3 ¦@4¤Ñ¾ã (36¤p®É) + 5/27 15:50 (¤@¤p®É¤S¤Q¤ÀÄÁ) + 6/4 13:46  (¤­¤p®É¤S46¤ÀÄÁ) = 42¤p®É¤S56¤ÀÄÁ

ML089

¦^´_ 1# fangsc

¤U¸ü (235.51 KB)

2014-7-11 21:41

¦Ò¼{
1. ¦©±¼©P¤»,©P¤é
2. ¦©±¼°ê©w°²¤é
3. ¦Ò¼{¤W¯Z®É¶¡ (8:00 ~ 17:00)¡A¤@¤Ñ¤u§@®É¼Æ¬° 9¤p®É

E7 =(MIN(17,MAX(8,MOD(C7,1)*24))-MAX(8,MIN(17,MOD(B7,1)*24))+(D7-1)*9)/24
Àx¦s®æ®æ¦¡ [h]"¤p""®É"mm"¤À"

F7 =MIN(17,MAX(8,MOD(C7,1)*24))-MAX(8,MIN(17,MOD(B7,1)*24))+(D7-1)*9
Àx¦s®æ®æ¦¡: 0.00"¤p""®É"

ML089

¦^´_ 9# fangsc

=MIN(17,MAX(8,MOD(C7,1)*24))-MAX(8,MIN(17,MOD(B7,1)*24))+(D7-1)*9

8¼Ó¤½¦¡¤¤ 8¡B17 ¬O«ü 8:00¡B17:00 ªº®É¶¡¡A * 9 ªí¥Ü¤@¤Ñªº¤u§@®É¶¡¡A³o¨Ç°Ñ¼Æ¥i¥H¨Ì·Ó§Aªº»Ý¨D­×§ï

ML089

¦^´_ 9# fangsc

«e­±ªº¤½¦¡¦³»~§@¼o

®É¶¡À³¸Ó­n©ú½T©w¸q¡A­p®É®É¬q¬° 8:00~12:00¡B13:00~17:00¡A¨C¤é8¤p®É
E7¤½¦¡
=((MIN(12,MAX(8,MOD(C7,1)*24))-MAX(8,MIN(12,MOD(B7,1)*24))) + (MIN(17,MAX(13,MOD(C7,1)*24))-MAX(13,MIN(17,MOD(B7,1)*24))) + (NETWORKDAYS(B7,C7,I$7:I$28)-1)*8)/24