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 following examples from text to time. The ultamite goal I have is to be able to count rows based on a filter that have a 'time less than 4 hours', 'time less than 24 hours', and then 'time greater than 24 hours'. My first step was to be able to convert the column containing these values to Time, but when I try, Power Bi throws a message that it cannot convert the column.
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.
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.