excel时间差的计算函数答:如果是同一天的很简单:=TEXT(TIME(MID(A2,12,2),MID(A2,15,2),MID(A2,18,2))-TIME(MID(A1,12,2),MID(A1,15,2),MID(A1,18,2)),"[h]小时mm分钟ss秒")跨天计算:=TEXT((DATE(MID(A2,1,4),MID(A2,6,2),MID(A2,9,2))+TIME(MID(A2,12,2),MID(A2,15,2),MID(A2,...
excel时间 if函数答:公式,直接输入即可 =IF(A2<>"",IF(AND(TIME(HOUR(A2),MINUTE(A2),SECOND(A2))>TIME(11,0,0),TIME(HOUR(A2),MINUTE(A2),SECOND(A2))<TIME(13,0,0)),"中餐",IF(AND(TIME(HOUR(A2),MINUTE(A2),SECOND(A2))>TIME(16,0,0),TIME(HOUR(A2),MINUTE(A2)...