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.
<tbody>
</tbody>
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.
| Formula to show if time is between |
| 05:00 to 12:59 = "Shift One" |
| 13:00 to 20:59 = "Shift Two" |
| 21:00 to 04:59 = Shift Three |
<tbody>
</tbody>
Last edited:
