Forum Discussion

Julius575's avatar
Julius575
Copper Contributor
Jun 28, 2022

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 time or early  to column W, should be tagged as "hit' in column Z.

 

 

 

 

excel
Formulas and Functions
    • Julius575's avatar
      Julius575
      Copper Contributor
      Jun 28, 2022

      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.

       

       

       

       

       

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Jun 28, 2022

        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".

Resources