Help converting text to date & time?
 

Rec'd date/time data as: "12/01/08@12:05 PM". Does anyone have an easy way to
conver this to date-time data for calculation in Excel?????

Help converting text to date & time?
 

Edit/ Find and Replace/ change @ to a space
or
=--SUBSTITUTE(A1,"@"," ") and format appropriately,
but in either case don't forget to tell your system (in Windows Regional
Settings under Control Panel) whether you are working in dd/mm/yy or
mm/dd/yy, as 12/01/08 is ambiguous.
--
David Biddulph


"Jon M" wrote in message
...
Rec'd date/time data as: "12/01/08@12:05 PM". Does anyone have an easy way
to
conver this to date-time data for calculation in Excel?????

Help converting text to date & time?
 

=DATEVALUE(LEFT(A7,8))+TIMEVALUE(RIGHT(A7,8))

Regards,
Stefi

€žJon M€� ezt Ã*rta:

Rec'd date/time data as: "12/01/08@12:05 PM". Does anyone have an easy way to
conver this to date-time data for calculation in Excel?????