Forum Discussion
Time tagging
Hi Excel Community, Pls assist formula for column Z. this is the scenario: if column S is more than or late on column W, should be tagged as "missed" in column Z. if column S is equal or same...
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.
got this! its working! thanks a lot.