本帖最后由 砂海 于 2013-11-28 15:51 编辑
E3
=INDEX({7.5,8,8.5,9,9.5,10,10.5,11,11.5,13.5,14,14.5,15,15.5,16,16.5,17,17.5,18.5,19,19.5,20,20.5,21,21.5},MATCH(D3*24+5/60,{7.5,8,8.5,9,9.5,10,10.5,11,11.5,13.5,14,14.5,15,15.5,16,16.5,17,17.5,18.5,19,19.5,20,20.5,21,21.5},1))-INDEX({21.5,21,20.5,20,19.5,19,18.5,17.5,17,16.5,16,15.5,15,14.5,14,13.5,11.5,11,10.5,10,9.5,9,8.5,8,7.5},MATCH(C3*24-5/60,{24,21,20.5,20,19.5,19,18.5,17.5,17,16.5,16,15.5,15,14.5,14,13.5,11.5,11,10.5,10,9.5,9,8.5,8,7.5},-1)) |