excel难题,跪求高手解答,在线等!!急急急急急急!!!

2025-06-28 12:57:36
推荐回答(1个)
回答1:

=IF((TEXT(A2,"h:m:s")+4/24+(B2="农村")*2/24+LOOKUP(HOUR(A2),{8,0;20.00001,8})/24)<--TEXT(C2-INT(A2),"[H]:m:s"),"超时","")