E2=IF(AND(D2>=TIME(8,0,0),D2<=TIME(20,0,0)),"day",IF(AND(D2>=TIME(0,0,0),D2<=TIME(8,0,0)),"night2",IF(AND(D2>=TIME(20,0,0),D2<=TIME(23,0,0)),"night1","b")))
C语言表达方式:
if(D2>=TIME(8,0,0)&&D2<=TIME(20,0,0))//满足条件：8:00-20:00之间的数据
{
E2="day";
}
else if(D2>=TIME(0,0,0)&&D2<=TIME(8,0,0))//满足条件：0:00-8:00之间的数据
{
E2="night2";
}
else if(D2>=TIME(20,0,0)&&D2<=TIME(23,0,0))//满足条件：20:00-23:00之间的数据
{
E2="night1";
}