if then else for timestamp

[sagarika]

=IF(A2<="12:00","Before Noon",IF(AND(A2>"12:00",A2<="15:00"),"After Noon",IF(AND(A2>"15:00",A2<"19:00"),"Evening","Night")))

I have a column of timestamps..i need to create buckets like before noon, post noon etc.
I am using the above formula but its not working. can anyone help me with it?

 

[Perdafircax]

Try converting all your "12:00" to Text("12:00", "HH:MM") to compare with, see if it works
=IF(A2<=Text("12:00", "HH:MM),"Before Noon",IF(AND(A2>Text("12:00", "HH:MM),A2<=Text("15:00", "HH:MM)),"After Noon",IF(AND(A2>Text("15:00", "HH:MM),A2<Text("19:00", "HH:MM)),"Evening","Night")))

 

[Tetra201]

Try

=IF(A2<=--"12:00","Before Noon",IF(AND(A2>--"12:00",A2<=--"15:00"),"After Noon",IF(AND(A2>--"15:00",A2<--"19:00"),"Evening","Night")))

 

[sagarika]

Hi..its not working. My column has the datatype of timestamp..do I need to convert it into some other type??..it still shows error in the formula

 

[sagarika]

all the values are coming as "Night"