» Determining Whether a Person Worked a Full or Partial Shift
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.
Use the IF and TIME functions as shown in the following formula:
=IF(IF(B2TIME(8,0,0),"Full Shift","Partial Shift")