Tip Printed from ExcelTip.com

---

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")