» Determining Whether a Person Worked a Full or Partial Shift
CATEGORY - Excel Date & Time Formulas
VERSION - 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
Book Store:
Recommended Books:
- Accounting for Dummies
- Marketing Management
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- The One Page Business Plan: Start With a Vision, Build a Company!
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Wall Street Journal Guide to Understanding Money and Investing
No comments have been submitted.
