excel 已知距离395km,时速50km/h,求运行时间,结果要显示:×小时××分...答:=TRUNC(395/50,0)&"小时"&IF((395/50)-TRUNC(395/50,0)>0,MINUTE((395/50)-TRUNC(395/50,0))&"分钟","")如果距离填在A1,时速在B1,那么公式为:=TRUNC(A1/B1,0)&"小时"&IF((A1/B1)-TRUNC(A1/B1,0)>0,MINUTE((A1/B1)-TRUNC(A1/B1,0))&"分钟","")...