Date Time In Text Format

[Rikuk]

I have been sent an excel sheet, that contains a text column with a date and time format below

24/04/2009 1700
15/05/2009 2359
16/04/2009 1400


Is it possible to convert this into date & time to use in a calculation.

Rik

[daddylonglegs]

Looks like putting a colon in the time will make it into a valid date/time so, if your times are in A2 down use this formula in B2

=REPLACE(A2,LEN(A2)-1,0,":")+0

format B2 in required date/time format and copy down column

[Rikuk]

Thanks Works great
Rik