» 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:
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The Guide to Understanding Financial Statements
- Microsoft Excel 2002 Simply Visual
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
