CCkfm2000
11-14-2006, 04:31 AM
hi all...
need help with a formula to look at a time and lookup relevent shift type.
e.g
if time is between 06:31 and 14:30 then shift type is E
if time is between 14:31 and 22:30 then shift type is L
if time is between 22:31 and 06:30 then shift type is N
i've attached an example file.
thanks
need help with a formula to look at a time and lookup relevent shift type.
e.g
if time is between 06:31 and 14:30 then shift type is E
if time is between 14:31 and 22:30 then shift type is L
if time is between 22:31 and 06:30 then shift type is N
i've attached an example file.
thanks