Forum Discussion
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 to populate Column H~K in a way that if the "isStatusReportRequested_" between 0~5ms then "YES" will be populated in Column "H", and so on
Attached is the Worksheet, I tried using IF, but not seems this didn't worked:-
Attached is the Worksheet.
Br,
Anupam
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", "")
3 Replies
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
Attaching again
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", "")
