请问想用EXCEL的公式计算两个日期所用时间,计算到天、小时、分_百度知...答:第一种情况 =(DATEDIF(A2,B2,"D")&"天"&HOUR(B2-A2))&"小时"&(MINUTE(B2-A2))&"分")第二种情况 =IF(AND(HOUR(A5)<=12,HOUR(B5)>13),(DATEDIF(A5,B5,"D")&"天"&HOUR(B5-A5)-2)&"小时"&(MINUTE(B5-A5))&"分",(DATEDIF(A5,B5,"D")&"天"&HOUR(B5-A5))&"小时"&...