输入公式就提示这个····
晕,一个引号打错了。改好了。
b2输入:
=IF(A2="","",VLOOKUP(A2,{"早班","6:00";"中班","12:00";"晚班","18:00"},2,0))
d2输入:
=IF(A2="","",VLOOKUP(A2,{"早班","12:00";"中班","18:00";"晚班","6:00"},2,0))
那个时间不一定是正6点,12点或者18点的,小时后面还有分钟
只要H7输入这公式就OK了,如果K7大于6点,就是早班,大于12点就是中班,大于18点就是晚班
明白了。
这样吧,你在h7输入:
=if(k7>(1/24)*18,"晚班",if(k7>(1/24)*12,"中班",if(k7>(1/24)*6,"早班","")))