how ot make shifts out of datetime data item in the report studio report query

[cognos74]

Hi Friends,

I have a question that how to make shifts out of Datetime column:

I have scheduled datetime (ex: Nov 3, 2017 8:00:00 PM) dataitem in my query.  out of that data item how can I make a shifts like below.  for ex if I run the report for startdate 11/03 and enddate 11/03

(5am to 5pm 1st shift and 5pm to 5am is the 2nd shift)

11/03                                      11/03 
05:00 to 16:59                       17:00 - 04:59

I can make shifts like datetime between 5 to 17 is ist shift else 2nd shift but here second shift is 5pm to 5am so it is making me confused how to use add_days or some other function in the expression.
it might be very easy for some of you so please help me.

Thanks in advance