If Functions for Lates
I want the formula to look in column A and if there is a 1 and column C is
greater than 15 minutes above column B I want it to return a "yes".. But if
Column A is not a 1 then I want to use 30 minutes as the standard. and
perform the same function. If the time in C is less than the 30 or 15 minutes
then I want it to return a "No"
I am trying to track the delivery times wether they were Late or Not and the
first stop we have a fifteen minute window while all others are 30 minutes
and early is not a problem.
Thanks To all who can contribute
|