This may be OT but see below....

Scott Moon wrote:

> I have a varchar field that stores timestamp data imported from a text
> file (CSV). I did not realize until it was too late that the timestamp
> data was in AM/PM instead of 24 hour format. I have tried manipulating
> the format in Excel to no effect. Does anyone know how to convert a
> string timestamp from AM/PM to 24-hour format?
>

create an extra column, and assuming your date is on column A, enter...

=DATEVALUE(A1) + TIMEVALUE(A1)

...and copy the formula down.

Format the new column as Date (Format -> Cells, Number, Date) ensuring
select the option with 24 hour timing.

Select the data in the new column and PASTE SPECIAL its _values_ /over
itself/:
Select NEW data
Edit >> Copy
With NEW data still selected
Edit >> Paste Special >> Values

Delete the old column, Rename the new column and... Voila!!

> Thanks,
> Scott Moon
>
>