I am trying to clean up data and reference between two different forms. I have data in a .csv file that I cannot change how it exports because it comes from a sensor that I dont have control over. What comes up in the cells time stamp is
2020-07-27T15.19.30.469.
this shows date and time put together in one cell. I know how to separate the date with the time by using the LEFT and MID function but when I pull what I want for the time it shows 15.19.30 and I cannot get that cell into the proper format to read as a time value and change it to be hh:mm:ss.0....... so it needs to be 15:19:30.4 so I can link it to my other data source which shows the correct format
in my sample file it shows the data that come from the sensor in Columns A to D
Column F is where I have the formula to pull out the date from Column B and I need Column F to show as the proper format hh:mm:ss.0 and changing it as a custom format doesnt work
Bookmarks