I have a spreadsheet that I received from someone else. It has a date column and a "Procedure Start Time*" column that is displayed as hh:mm:ss.000. Ultimately, I want to concatenate the date and time into a single column, formatted as mm/dd/yyyy hh:mm:ss AND be able to filter the new, combined column by group (ordinarily displayed as a "tree").
No matter what I do to the "Procedure Start Time*" column, once it is combined with the date, I am not able to filter by group.
Here are the things I've tried so far:
1) I've formatted Column B as "hh:mm:ss.000"
2) I've repeatedly tried data text to columns, formatting each piece separately and then re-combining them by using the TIME formula
3) I've tried cleaning and trimming
4) I've copied pasted "values only"
5) I've tried converting the time to a decimal number and tried to re-convert it back to a number
6) I've copied to an entirely new sheet
7) I've tried numerous different TIME and TIMEVALUE formulas
Although I can get the new, "combined" column to "look" right, I cannot get it to filter correctly. Based on all of my research today, it has something to do with the time column. The date piece seems to be fine.
I would welcome ANY suggestions. I am an Intermediate to Intermediate Advanced user, not an Expert.
Thanks in advance!
Diane
Bookmarks