请问想用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))&"小时"&...
在EXCEL中,怎样计算同一列中的两个时间差值。答:下面以A5,B5为例,C5中填=(DAYS360(DATE(YEAR(A5),MONTH(A5),DAY(A5)),DATE(YEAR(B5),MONTH(B5),DAY(B5)))*24+HOUR(TIMEVALUE(TEXT(TIME(HOUR(B5),MINUTE(B5),0),"HH:mm")))-HOUR(TIMEVALUE(TEXT(TIME(HOUR(A5),MINUTE(A5),0),"HH:mm")))+(...