|  

» Determining Whether a Worked Shift Was Morning, Afternoon or Night

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

Rate This Tip
12 34 5
Rating: 2.44     Views: 16491
No comments have been submitted.
Name
Comment Title
Comments