Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Time Filter - 19:00-07:00

I have a column with 60,000+ rows, the format of which is:   07:00 08:23 22:01   Any idea how I could apply a quick filter for times between 19:00 - 07:00?    
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Based on my test, you could refer to below formula:

    Column = IF([Time]>=TIME(19,0,0)||[Time]<=TIME(7,0,0),1,0)

    Result:

     

    Regards,

    Daniel He

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If I do a filter of :

 

is greater than or equal to 19, and lower than or equal to 7

 

It shows 0 records. Which is strange because there are records in that range.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Change it from AND to OR