Forum Discussion
Time tagging
Riny_van_Eekelen hi there, just tried the formula provided but, on the first line sample this should be tagged as missed since column W(actual delivery date & time did not meet the column S(Agreed date & time). pls refer on the 2nd figure below.
Julius575 Can't tell based on a picture. But I suspect that the date/time stamps a texts and that the actual time has two spaces between the date and the time. Then, based on comparing texts, the Actual is less then the Planned, thus "HIT".
- can i share the file with you sir?
sharing fie with you Riny, for your checking
Julius575 Exactly as I mentioned. The values in A and E are texts and you have two spaces between the date and time part in E. When you fix that, you'll see that the values become right-justified indication that they are numerical (date and time) values.
You can easily fix that with Text to Columns (TTC) on the Data ribbon. Select column A and press TTC. Step 1: Delimited, Next
Step 2: Change nothing, Next
Step 3: Set the data format to Date and MDY
Press finish.
Did that in the attached file.