» 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 Intelligent Investor: The Classic Bestseller on Value Investing
• Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
• The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
• Microsoft Excel 2002 Formulas (With CD-ROM)
• Financial Statement Analysis with S&P insert card
• The New Financial Order: Risk in the Twenty-First Century

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 2.00     Views: 12705

No comments have been submitted.

Name

Comment Title

Comments