» Determining Whether a Person Worked a Full or Partial Shift
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Columns A & B contain times signed in and out of work.
A full shift includes at least 8 hours; any period less than 8 hours is considered a partial shift.
We want to determine the type of shift corresponding with each pair of time values.
Solution:
Use the IF and TIME functions as shown in the following formula:
=IF(IF(B2
Book Store:
Recommended Books:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Microsoft Windows XP Step by Step (With CD-ROM)
- Understanding Financial Statements
- The 22 Immutable Laws of Branding
- Business Analysis with Microsoft Excel (2nd Edition)
- Financial Risk Manager Handbook, Second Edition
No comments have been submitted.
