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

[µo°Ý] ½Ð±ÐEXCEL®É¶¡®æ¦¡³]©w

[µo°Ý] ½Ð±ÐEXCEL®É¶¡®æ¦¡³]©w

¦U¦ì¤j¤j­Ì¦n¡G
¦³­Ó°ÝÃD·Q½Ð±Ð¤@¤U¡A
AÄæ¬O¨â­Ó®É¶¡¬Û´îªºµ²ªG(®æ¦¡¬O¦Û­qhh:mm)
BÄæ¬O­pºâAÄæ«áªº¤p®É¼Æ­È(®æ¦¡¬O³q¥Î)

              A               B
1        02:58            3
2        17:18          17
3        05:45          5.5
4        04:35          4.5
5        

½Ð°Ý
1.A5ªº¤½¦¡¬O±NA1¨ìA4¥[Á`«á¡A·Q§e²{¡u30¤p®É36¤À¡v¡A½Ð°ÝA5ªº¤½¦¡¤Î®æ¦¡­n¦p¦ó³]©w¡H
2.B5ªº¤½¦¡¤]¬O±NB1¨ìB4¥[Á`¡A·Q§e²{»PA5¬Û¦Pªº®æ¦¡¡A½Ð°ÝB5ªº¤½¦¡¤Î®æ¦¡­n¦p¦ó³]©w¡H
3.³Ì«áA5¤ÎB5°µ¤ñ¸û¡A®É¶¡¤ñ¸û¤jªº§e²{¶À©³¬õ¦r¡A½Ð°Ý­n¦p¦ó³]©w¡H

ÁÂÁÂ

¦^´_ 1# takeshilin88

1.  ¦]¬°¶W¹L24¤p®É©Ò¥H¨S¿ìªkÅã¥Ü30¤p®É¡A©Ò¥H...
     A5 =CONCATENATE(SUM(HOUR(A1:A4))+QUOTIENT(SUM(MINUTE(A1:A4)),60)," ¤p®É ",TEXT(MOD(SUM(MINUTE(A1:A4)),60),"00")," ¤À")  °}¦C
2. B5 =CONCATENATE(SUM(HOUR(B1:B4))+QUOTIENT(SUM(MINUTE(B1:B4)),60)," ¤p®É ",TEXT(MOD(SUM(MINUTE(B1:B4)),60),"00")," ¤À")  °}¦C
3. ¦]¬°§Ú·Q¤£¥X¨Ó«ç»òª½±µ§PÂ_¡A©Ò¥H¥ýÂন¼Æ­È¦A¤ñ¸û
     A6 =VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A5,"¤À",""),"¤p®É","")," ",""))
     B6 =VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B5,"¤À",""),"¤p®É","")," ",""))
    ¦A¥Î®æ¦¡¤Æ±ø¥ó¤ñ¸ûA6&B6­þ¤@­Ó¼Æ­È¤j¡A³Ì«á¤~±NÃC¦â©ñ¨ìA5&B5

©Ò¾Ç¦³­­¡A¥u·Q¨ì³o¼Ë³B²z...

TOP

A5:=SUM(A1:A4)
B5:=SUM(B1:B4)/24
Àx¦s®æ®æ¦¡:[h]:mm §Y¥iÅã¥Ü 30:36

®æ¦¡¤Æ¥u¬O[¤j¤_]§PÂ_, «Ü²³æ, ¥i¦Û¦æ°Ê¤â¥h¸Õ!!!

TOP

ÁÂÁ¤j¤j¡A¤w¸Ñ¨M¡AÁÂÁÂ

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