if ( and (hour(单元格) >= '06', hour(单元格) < '18'), 'A', 'B')

再多给几笔数据，单看这个不好判别

=if(hour(日期)>=8 and hour(日期)<20,"白班","夜班")

我这个日期是字符串类型  拉到单元格后设置成了时间类型

SQL里写，再把数据集拉上去，我这星期天加了个中班，看需求更改

WITH HHHH AS(

SELECT DECODE(TO_CHAR((SYSDATE),'D')-1,'0','7',TO_CHAR((SYSDATE),'D')-1)  AS DAYNUM FROM DUAL 

)

SELECT A.*,SYSDATE,

CASE WHEN(DAYNUM<>7 AND SYSDATE>(TRUNC(SYSDATE)+8/24) AND SYSDATE<(TRUNC(SYSDATE)+20/24)) THEN '白班'

     WHEN(DAYNUM<>7 AND SYSDATE>(TRUNC(SYSDATE)+20/24) AND SYSDATE<(TRUNC(SYSDATE+1)+8/24)) THEN '夜班'

WHEN(DAYNUM=7 AND SYSDATE>(TRUNC(SYSDATE)+8/24) AND SYSDATE<(TRUNC(SYSDATE)+16/24)) THEN '白班'

WHEN(DAYNUM=7 AND SYSDATE>(TRUNC(SYSDATE)+16/24) AND SYSDATE<(TRUNC(SYSDATE)+24/24)) THEN '中班'

WHEN(DAYNUM=7 AND SYSDATE>(TRUNC(SYSDATE)+24/24) AND SYSDATE<(TRUNC(SYSDATE+1)+8/24)) THEN '夜班'

END TYPE   

FROM HHHH A