IF statement repeated multiple times

Hi,

Can someone please help me.

I have a Cell with a drop down list with the 24 hour clock in 5 min periods (example 06:00, 06:05, 06:10 - on so on)

now I need a cell that can read between two values to return TEXT back, but for 3 separate IF statements.

so basically, if the time is between X,Y = Day shift. if the time is between A,B = Evening Shift. If the time is between C,D = Night Sh

IF(K1>=06:30,<=14:29)"Day Shift","" + IF(K1>=15:00,<=22:59),"Evening Shift","" + 'IF(K1>=23:00,<=06:29),"Night Shift",""

Originally Posted by Glenn Kennedy

Try this:

=IF(AND(K1>=TIME(6,30,),K1<=TIME(14,59,)),"Day Shift",IF(AND(K1>=TIME(15,0,),K1<=TIME(22,59,)),"Evening Shift",IF(OR(K1>=TIME(23,0,),K1<=TIME(6,29,)),"Night Shift","")))

That worked, Thank you very much Glen.