The correct syntax would be:

=IF(AND(H3="Mr D",OR
(J3="Mon",J3="Tues",J3="Wed",J3="Thurs",J3="Fri")) ,"12-1pm",IF(AND
(H3="Mr O", OR
(J3="Mon",J3="Tues",J3="Wed",J3="Thurs",J3="Fri")) ,"7.45-8.45am",""))

This will return a blank if those conditions are not met.

Hope this helps.

Pete

On Oct 12, 6:37*pm, Romileyrunner1
wrote:
Hi,
I want to do something on the lines of ....

=IF(H3="Mr D", AND IF(J3={"Mon", "Tues", "Wed","Thurs","Fri"},12-1pm),IF
(H3="Mr O, AND IF(J3={"Mon", "Tues", "Wed","Thurs","Fri"}7.45-8.45am)

If that makes any sense to anybody AND IF ANYONE CAN SORT IT OUT, I would be
very grateful.
Thanks folks.
RR1