...设个公式计算时间差的。时间差结果以小时为单位。小数点保留后一位...答:A-B时间:=ROUND((SUBSTITUTE(SUBSTITUTE(B2,"月","-"),"日"," ")-SUBSTITUTE(SUBSTITUTE(A2,"月","-"),"日"," "))*24,1)B-C时间:=ROUND((SUBSTITUTE(SUBSTITUTE(C2,"月","-"),"日"," ")-SUBSTITUTE(SUBSTITUTE(B2,"月","-"),"日"," "))*24,1)A-C时间:=ROUND((...
Excel中怎么把文本格式的时间转化为数字,并计算时间差(以小时为单位...答:=TEXT(DATE(RIGHT(LEFT(B2,FIND(" ",B2)-1),4),LEFT(B2,FIND("/",B2)-1),MID(LEFT(B2,FIND(" ",B2)-6),FIND("/",B2)+1,2))+MID(B2,FIND(" ",B2)+1,11)-(DATE(RIGHT(LEFT(A2,FIND(" ",A2)-1),4)