Prev: Change default font for new entries
Next: How do I calculate a persons age from birth dates
From: mlman on 27 May 2010 16:59
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?
From: Mike H on 27 May 2010 17:36
Hi,

have a look at 'Data|Text to columns' and use the full stop as the delimeter



--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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?
 | 
Pages: 1
Prev: Change default font for new entries
Next: How do I calculate a persons age from birth dates