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

[µo°Ý] ®É¶¡´«ºâ¤ÀÄÁ

[µo°Ý] ®É¶¡´«ºâ¤ÀÄÁ

½Ð°Ý¤j¤j­Ì:  1:15  ¤@¤p®É¤S15¤À¦p¦ó´«¦¨ 15¤À¬°¤@³æ¦ì¡Aºâ¥Xµ²ªG¬° 5
                 3:15ºâ¥Xµ²ªG¬° 13  ©O?
celina710828

=A1/(1/24/4)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

gong¤j¤j±z¦n:«Ü°ª¿³±zªº¦^ÂСA¦ý¬O§ÚªºÀx¦s®æ¤WÁÙ¦³FJ5=SUM(EE5:FI5)¥[Á`,
FK5=FJ5/(1/24/4)µ²ªG·|¬O1441ªº­È
celina710828

TOP

SUM(EE5:FI5)·|¥X²{¤°»òµ²ªG
·|¬O´X¤Ñ¶Ü,¨º¥Î
=MOD(A1,1)/(1/24/4)
¤W¶ÇÀɮפ~ª¾¹D¤°»ò°ÝÃD
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

=IF(D5>=$G$1,D5-"08:00","0")
=CEILING(F5,"0:15")
½Ð°Ý¤j¤j§Ú«ç»ò§â¤W¨â­Ó¨ç¼Æ©M°_¨Ó¡AµM«á¦A¥[­nºâ¥X¨Óªº­È©O?
1:15  ¤@¤p®É¤S15¤À¦p¦ó´«¦¨ 15¤À¬°¤@³æ¦ì¡Aºâ¥Xµ²ªG¬° 5¡A
                 3:15ºâ¥Xµ²ªG¬° 13  ©O?
¥[¯Z«e¨â­Ó¤p®É¬O®ÉÁ~*1.33«á¨â­Ó¤p®É¬O*1.66

­û¤u¦Ò¶Ô.zip (34.41 KB)

celina710828

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2011-4-17 10:17 ½s¿è

j5=CEILING(MAX(0,$D5-$G$1),1/24/4)*24*4
k5=MIN(8,FLOOR(MAX(0,$E5-$N$1),1/24/4)*24*4)
=MAX(0,FLOOR(MAX(0,$E5-$N$1),1/24/4)*24*4-$K5)

FÄæ:IÄæ¥Î¤£¨ì¥i¥H§R°£

¥¼©R¦W.GIF (71.79 KB)

¥¼©R¦W.GIF

Xl0000002.rar (19.56 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

b5¥i¥H§ï¦¨³o¼Ë¤ñ¸û²³æ
=TEXT(A5,"[$-804]aaa")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

ÁÂÁ¤j¤j§Ú¤w¸gok¤F¡A·PÁ·PÁ¦A·PÁÂ
celina710828

TOP

¤j¤j¥i¥H¸Ñ»¡¤U¶Ü?§Ú·Qª¾¹D¥H¤Uªººâªk¥i¶Ü?
j5=CEILING(MAX(0,$D5-$G$1),1/24/4)*24*4
k5=MIN(8,FLOOR(MAX(0,$E5-$N$1),1/24/4)*24*4)
=MAX(0,FLOOR(MAX(0,$E5-$N$1),1/24/4)*24*4-$K5)
¿ð¨ì¬O¥i¥Hªº¡A¦ý§Ú¥[¯Z¬O¥H30¤À¬°¤@­Ó³æ¦ì¡A§Ú·Q»¡¥ý°Ý15¤À¬°¤@­Ó³æ¦ì¡A¤§«á§Ú´N¥i¥H¦Û¦æ¥h­×§ï30¤À¬°¤@­Ó³æ¦ì¡A¦ý§Ú¬Ý¤£À´Y
¨º»ò¥i¥H¦b¥[¤W
=IF(C5<6,E5-D5,"")¬P´Á¤@~¬P´Á¤­ªº¤u§@¤Ñ
=IF(C5>5,E5-D5,"")¬P´Á¤»©M¬P´Á¤éªº¤u§@¤Ñ
³o¨â­Ó¨ç¼Æ¦p¦ó©ñ¦b¤@°_¶Ü?
¦ý¦pªG¹J¨ì¿ð¨ì¤S¦­°h«ç»ò¿ì
celina710828

TOP

1.1/24/4,¤@¤Ñ¬O1,/24ªí¥Ü¤@¤p®É,/4ªí¥Ü15¤ÀÄÁ,§ï30¤ÀÄÁ/2´N¥i¥H¤F
2.ºâ§¹«á¬O¥H15¤ÀÄÁ¬°³æ¦ì,¦p¥H¾ã¼Æªí¥Ü,´N­n*4*24
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD