Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Nov 19, 2025
Solved

Filter function with Time criteria

Dear Experts,                    I have a data like below:- For a Single rnti== 17975(say), and in Column No B is the time-difference between each rows for this rnti, for lcid==4 (column=F) I want...
BI & Data Analysis
excel
Formulas and Functions
office 365
  • m_tarler's avatar
    m_tarler
    Nov 19, 2025

    The problem is that "00:00:00.005" is TEXT not a number you need to convert that to a number.  Here are some options:

    =IF(AND(B2<TIMEVALUE("00:00:00.005"), G2="YES"), "YES", "")
    =IF(AND(B2<0.005/24/3600, G2="YES"), "YES", "")
    =IF(AND(B2<--"00:00:00.005", G2="YES"), "YES", "")

     

anupambit1797's avatar
anupambit1797
Iron Contributor
Nov 19, 2025

Thanks a lot m_tarler​ , how can we extend this to populate this for all the rnti's for lcid==4, in this sheet

Note , that each rnti has it's own time difference( it's own machinery), so I don't know first on how to get the time-diff Column for each rnti, and then populate the ones with the criterion's of 0~5ms and so on.

 

Br,

Anupam

Resources