if formula

[Guest]

Hi All,

I have a worksheet with following coloumns:-

C2 D2 F2
Movement Start Time End Time

No Movement 07:45:12 9:12:45
At Fresh Beans 14:00:00 15:45:00


On K2 I want formula which returns
1. If C2 = No Movment then "----" and if D2 is less than 08:00:00 and F2
is greater than 17:00:00 then "Private" otherwise "Business"


Thanks & Regards

Hassan

 

[Bill Kuunders]

=IF(C2="no movement","-----",IF(AND(D2<0.33,F2>0.71),"Private","Business"))

regards