|
» Determining Whether a Person Worked a Full or Partial Shift
CATEGORY: Excel Date & Time Formulas |
VERSIONS: All Microsoft Excel Versions |
|
Problem: 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 |
|
RATING:
2.33
VIEWS: 7232 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Microsoft Windows XP Step by Step (With CD-ROM)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Microsoft Word Version 2002 Inside Out
- Microsoft Outlook 2002 for Dummies
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
