hi all.
is there a way to perform the following?
in range sheet 2 H22:H39 look for value Sheet3 B3 and if that value is between sheet 3 L11 and M11 return 1, otherwise return 0.
also, the values in these ranges are times formatted as h:mm
any help would be great.
thank you.
EDIT..... now I...