» Determining Whether a Worked Shift Was Morning, Afternoon or Night
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Seven Habits Of Highly Effective People
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Analyzing Markets, Products, and Marketing Plans
- Yes, You Can Time the Market!
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
