如何计算excel中如何计算两个日期相差多少天时分,求第三个的公式
时间分别在A列和B列,
输入公式:=IFERROR(INT(DATEDIF(A2,B2,"YD")+(TIME(HOUR(B2),MINUTE(B2),0)-TIME(HOUR(A2),MINUTE(A2),0)))&"天"&INT(MOD(DATEDIF(A2,B2,"YD")+(TIME(HOUR(B2),MINUTE(B2),0)-TIME(HOUR(A2),MINUTE(A2),0)),1)*24)&"小时"&ROUND(MOD((DATEDIF(A2,B2,"YD")+(TIME(HOUR(B2),MINUTE(B2),0)-TIME(HOUR(A2),MINUTE(A2),0)))*24,1)*60,0)&"分","")
=IFERROR(TEXT(B3-A3,"d天h小时mm分"),"")
上一篇:这题怎么做?
热门标签: