Forum Discussion

Marcjc's avatar
Marcjc
Regular Visitor
8 years ago
Solved

Text to Time - different text format

I know that there are a lot of text / time conversion discussions on the site, but none of them seem to fit my situation. I am hoping someone may be able to assist me with how I can convert the follo...
Need Help
Marcjc's avatar
Marcjc
Regular Visitor
8 years ago

Thank you for the quick reply... I am not really worried about how the time is displayed in the converted column in the table because the ultimate goal is to present a single number (count) of the rows that fit the filter criteria. 

Marcjc's avatar
Marcjc
Regular Visitor
8 years ago

Sample data for review. 

 

 

 

    • Marcjc's avatar
      Marcjc
      Regular Visitor
      8 years ago

      Anonymous,

       

      Thank you. I was able to use this. I ended up adding the seconds conversion to my filter and then used advanced filtering for less than or greater than my requirements. Thank you for this! I have marked it as the solution.