下面以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")))+(MINUTE(TIMEVALUE(TEXT(TIME(HOUR(B5),MINUTE(B5),0),"HH:mm")))-MINUTE(TIMEVALUE(TEXT(TIME(HOUR(A5),MINUTE(A5),0),"HH:mm"))))/60)A5,B5表格的格式必须是时间格式其他的鼠标放C5上出现+的时候往下拖就可以了
温馨提示:答案为网友推荐,仅供参考