excel if函数答:=IF(G8<>"",IF(F8=G8,"按时完成",IF(F8>G8,"提前完成","延迟完成")),IF(F8="持续执行","持续执行",IF(TODAY()>F8,"未完成","未到时间")))
excel表格中10:30-15:30 17:00-20:00 20:30-次日00:00如何函数表达出总...答:如果所有数据都是这个格式,数据在A列,B1用公式:=TEXT(SUM(MID(A1,{7,19,33},5)-MID(A1,{1,13,25},5),1),"[h]小时m分s秒")下拉。