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 Let's say your first formula in W is on row 10, then enter this in W10:
=IF(W10>S10,"MISSED","HIT")
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?
