Solved: lookup time and get type

[CCkfm2000]

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

[Charlize]

Try something like this :

IF(AND(C9 > TIME(6;30;0);C9 < TIME(14;31;0));"E";IF(AND(C9 > TIME(14;30;0);C9 < TIME(22;31;0));"L";"N"))

Charlize

ps.: Maybe you need to use , instead of ;

[CCkfm2000]

thanks that works great.

had to change ; to ,