如何计算excel中如何计算两个日期相差多少天时分，求第三个的公式

更新时间2021-07-24 13:20:48

时间分别在A列和Ｂ列，

输入公式：=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分"),"")