» Determining Whether a Worked Shift Was Morning, Afternoon or Night
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
Recommended Books:
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Understanding Financial Statements
- Excel 2002 Power Programming with VBA
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.
