LinkBack URL
About LinkBacks
= 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
= 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
Last edited by mmanning; 09-25-2013 at 04:59 PM. Reason: To comply with the rules
Bump. OP has complied with moderator request.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Do you mean?
=IF(AND(L2 >= U2, M2>=V2),"no","yes")
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.
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
post an example worksheet. Not a pic!
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.
That is beautifull thansk man!!!
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.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks