ExcelBanter - Converting a non recognizable date time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Converting a non recognizable date time (https://www.excelbanter.com/excel-discussion-misc-queries/264569-re-converting-non-recognizable-date-time.html)

mlman

Converting a non recognizable date time

Thanks for your help!

"mlman" wrote:

I have high speed monitoring equipment that imports thousands of date time
readings as follows:
05/24/2010 14:20:00.000.084

Excel does not recognize it as a date time and I only need:
05/24/2010 14:20:00

Is there a way to convert the unrecognizable date time to a usable date time?

All times are GMT +1. The time now is 04:51 PM.