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

[µo°Ý] ½Ð±Ðexcel®É¶¡­pºâ°ÝÃD>

b4=IF(ROW()=4,$B$1,B3)+$D$1/COUNTA($A$4:$A$13)/1440

TOP

1¤p®É=60¤À
1¤Ñ=24¤p®É
60*24=1440

TOP

¦^´_ 7# peter460191


    =ROUND(A1*1440,)/1440

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD