大家好，我的问题是excel中能不能直接设个公式计算时间差的。时间差结果以小时为单位。小数点保留后一位

Question

是小数点后面保留一位。例如时间差是15.2

Answer 1

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((SUBSTITUTE(SUBSTITUTE(C2,"月","-"),"日"," ")-SUBSTITUTE(SUBSTITUTE(A2,"月","-"),"日"," "))*24,1)本回答被提问者采纳

Answer 2

在D2:F2中分别输入或复制粘贴下列公式之一
=ROUND((MAX(A2,B2)-MIN(A2,B2))*24,1)
=ROUND((MAX(B2,C2)-MIN(B2,C2))*24,1)
=ROUND((MAX(A2,C2)-MIN(A2,C2))*24,1)
选中D2:F2，下拉填充
选中D:F三列，设置单元格格式为常规。本回答被网友采纳

Answer 3

A-B 时间差：D2单元格=ROUND((B2-A2)*24,1)
B-C时间差：E2单元格=ROUND((C2-B2)*24,1)
A-C时间差：F2单元格=ROUND((C2-A2)*24,1)

Answer 4

格式自定义为 HH"小时"

Answer 5

=ROUND((MAX(A2,B2)-MIN(A2,B2))*24,1
=ROUND((MAX(B2,C2)-MIN(B2,C2))*24,1
=ROUND((MAX(A2,C2)-MIN(A2,C2))*24,1