» Determining Whether a Person Worked a Full or Partial Shift

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(B2TIME(8,0,0),"Full Shift","Partial Shift")

Book Store:

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

Recommended Books:

• The Analysis and Use of Financial Statements
• Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
• The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
• Learn MS Excel 2002 VBA/XML Programming
• Positioning: The Battle for Your Mind
• Investing in Real Estate, Fourth Edition

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 2.00     Views: 11415

No comments have been submitted.

Click here to post comment

For Registered Users

Click here to Regiser

For Guest

Name

Comment Title

Comments