» 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

Book Store:

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

Recommended Books:

• Microsoft Office XP Step-By-Step (With CD-ROM)
• Financial Reporting and Analysis (2nd Edition)
• The 22 Immutable Laws of Branding
• Keys to Reading an Annual Report (Barron's Business Keys)
• Definitive Guide to Excel VBA
• Good to Great: Why Some Companies Make the Leap... and Others Don't

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 2.67     Views: 9747

Where's the rest of this?

cmxsevenfoldxmc

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

oldchippy

You may have to buy the book to find the answer, it's on page 151, see link

[url]http://www.exceltip.com/pl-f1ff_contents[/url]

or you could place your question in this forum?

daddylonglegs

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"

Click here to post comment

For Registered Users

Click here to Regiser

For Guest

Name

Comment Title

Comments