If Formula

[vani2004]

Column A will have time like 09:00 (09:00 is save in text format)
Formula in Column B to show Shift one, Shift two or Shift three depending on time shown in column A
I tried =if(A1=09:00,"Shift One",if(A1=20:00,"Shift two","Shift Three")) but this formula isn't working.



[TABLE="width: 212"]
<tbody>[TR]
[TD="width: 283, bgcolor: transparent"]Formula to show if time is between
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]05:00 to 12:59 = "Shift One"
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]13:00 to 20:59 = "Shift Two"
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]21:00 to 04:59 = Shift Three

[/TD]
[/TR]
</tbody>[/TABLE]

 

[vani2004]

I figured it out. Sorry!