PDA

View Full Version : Solved: lookup time and get type



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

Charlize
11-14-2006, 05:10 AM
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
11-14-2006, 06:01 AM
thanks that works great.

had to change ; to ,