Thread: 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

Where's the rest of the tip? I've been looking for this one tip for days and now that I finally find it, it's incomplete. Can the rest be posted up? Or what do I need to do to see the rest?

Thanks

Don't know what the tip actually says but this is a fairly basic IF formula

=IF(A2>=2/3,"Night",IF(A2>=0.5,"Afternoon","Morning"))&" Shift"

..or with LOOKUP

=LOOKUP(HOUR(A2),{0,12,16},{"Morning","Afternoon","Night"})&" Shift"