I am running an import to bring in time from another workbook. However, I am getting the date pulled in as well as "1/1/1900" depending on which worksheet I import from. I can not seem to find the code to truncate the data in the cell to drop this date?
i.e - the cell value is showing "1/1/1900 3:00:00 AM". I need "3:00:00 AM" as the value.