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", "")

     

m_tarler's avatar
m_tarler
Bronze Contributor
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", "")

 

Resources