=IF function with 4 Cells that need compared

[mmanning]

= IF(AND(L2 >= U2 & M2 >= V2,L2 < U2 & M2 < V2),"No","Yes")

L2 = 9/21/2013
U2 = 9/21/2013
M2 = 23:59
V2 = 22:05

I'm Getting Yes for this.... Help please

[alansidman]

Bump. OP has complied with moderator request.

[apla]

Do you mean?

=IF(AND(L2 >= U2, M2>=V2),"no","yes")

[mmanning]

No I need to compare the Date and Time(two seperate cells), If the apointment time and date is > the drivers arrival time and arrival date then it should put No in the Late coulmn I created I have the example below in a picture. There will be another post to elaborate on my final goal which I'm sure I will need help with.

Excel Example.GIF

[mmanning]

To elaborate on the issue, my final goal is to Find what Pick-ups are late and what deliveries are late then relate them to a graph showing what day of the week holds the most late to see if there is a pattern in missed loads shipping through my company, any Idea's on the Graphing of the week days would be greatly appreciated as well, hope this helps.

[apla]

post an example worksheet. Not a pic!

[alansidman]

try: =IF(L2+M2>=U2+V2,"Yes","No")

The & is an addition for concatenation of text. Excel treats dates and time as numbers. Dates are integers and time are decimals.

[mmanning]

That is beautifull thansk man!!!

[Fotis1991]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.