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