Problem:
We want to use the sign-in times from column A to determine whether a person was starting a morning, an afternoon, or a night shift.
For times before 12:00, the formula should return \"Morning Shift\".
For times between 12:00 and 16:00 the formula should return \"Afternoon Shift\".
For times after 16:00, the formula should return \"Night Shift\".
Solution:
Use the IF and TIME functions as shown in the following formula:
=IF(A2
Bookmarks