=IF(LEFT(J3)<"S",IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"")


"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