Hi All,

I say several condition because I would like a cell run the operation when date is actual date, it is a weekly schedule, first row is date, at righ is Morning Schedule time to get in, second is time to leave, the fourth row is having afternoon schedule, to get in and time to go out, some times it says Please Call office when seller not going.

The first condition is the Date, Which is in A4, A5, A6, A7, A8, A9 and A10,

Second Condition is to calculate the actual time plus one hour because my computer is having one hour behind, due to is conected to a server in another country and I can not change the time.

If the actual time plus one hour is between the arrival time (b4) and departure time (c4) in the morning and betwew arrival time (d4) and departure time (e4) in the afternoon then say "IN", but this will depend on the fist condition on the date.

Or we could say.

If actual time plus one hour is => than arrival time (b4) and =< than departure time (c4) in the morning, or => than arrival time (d4) and =< than departure time (e4) the print "IN"

I would like it say "Out" if the conditions are not right.

The second problem is the schedule says Please Call Office in arrival and Departure times when the seller is not at the point so the clients call the office,
how we could manage this with the formula?

There are many sales spots and many seller, I will have a list of all the spots with a cell at righ saying if the seller is actually at the spot, so I can see at the moment which sales spot are covered by every seller and where is every seller actually.

Thanks

The document is attached as an image, and Any question please let me know

SELLERS NAME IS: ALFREDO
MORNING AFTERNOON
FROM TO FROM TO
Dec 28 8:00 AM 12:00 PM PLEASE CALL OFFICE
Dec 29 8:00 AM 10:00 AM 2:00 PM 4:00 PM
Dec 30 PLEASE CALL OFFICE 2:00 PM 6:00 PM
Dec 31 9:00 AM 11:00 AM 4:00 PM 6:00 PM
Jan 01 11:00 AM 12:00 PM PLEASE CALL OFFICE
Jan 02 10:00 AM 12:00 PM 3:00 PM 5:00 PM
Jan 03 PLEASE CALL OFFICE 2:00 PM 6:00 PM