convert general to date

[Odd sent date when open attachment OWA]

I have imported a text file where all fields were character and came in as
general. They look like:
Nov 17 2009 9:39AM
I want to compute time differences between columns, but I can't get them
converted to Date/Time format.
Thanks very much for any ideas.

 

[Odd sent date when open attachment OWA]

I'm not getting this to work right. Do I have to enter this formula cell by
cell? I tried it in on one cell and it seems to give the cell the data from
the cell below it.
Thank you very much for your help with this.

 

[Gord Dibben]

Luke assumes your "dates" are in column A starting at A2.

Enter the fomula in B2 and double-click on fill handle of B2 to copy down
with A2 incrementing to A3, A4 etc.

If "dates" are somewhere else, use a helper column and change A2 to the
actual starting cell.


Gord Dibben MS Excel MVP