Query IF ELSE OR - IDK

Hello.   Have a (in my head) easy query but i don't know how to get it done without a syntax or an error.   i have two rows: Date and a Time   this is for a tree shift model. so in CW 1 shift ...