ML089

¦^´_ 1# Cyssuc

¦­¤W 8~12¡A¤U¤È 13~17

= ¦­¤W®É¼Æ + ¤U¤È®É¼Æ
= MAX(0,MIN(12,Q2)-MAX(8,P2)) + MAX(0,MIN(17,Q2)-MAX(13,P2))

©Î
=IF(AND(P2>0,Q2>0), MAX(0,MIN(12,Q2)-MAX(8,P2)) + MAX(0,MIN(17,Q2)-MAX(13,P2)), "")

ML089

¦^´_ 5# Cyssuc

³o¼Ë­þ¸Ì¦³¿ù?

¤U¸ü (72.5 KB)

2014-9-9 15:23

ML089

¦^´_ 3# Cyssuc

    8        14.5
µª®×À³¸Óµ¥©ó14.5-8-1
¬Gµ¥©ó5.5

¤U¸ü (80.39 KB)

2014-9-9 16:09

ML089

¦^´_ 8# Cyssuc

¥i¯à»Ý­n«öF9­«·s­pºâ

¤£µM±N³¡¤À¸ê®ÆÀɮפW¶Ç¡A§ÚÀ°§A¬Ý¬Ý°ÝÃD¦b­þ¸Ì

ML089

¦^´_ 11# Cyssuc

§Aªº¸ê®Æ¬O¤å¦r®æ¦¡¡A·íµM·|¿ù»~

¤½¦¡­×§ï¦p¤U

¦­¤W 8~12¡A¤U¤È 13~17

= ¦­¤W®É¼Æ + ¤U¤È®É¼Æ
= MAX(0,MIN(12,Q2*1)-MAX(8,P2*1)) + MAX(0,MIN(17,Q2*1)-MAX(13,P2*1))

©Îª½±µ¥Î¨Ó·½
= MAX(0,MIN(12/24,G2)-MAX(8/24,E2)) + MAX(0,MIN(17/24,G2)-MAX(13/24,E2))