Help converting text to date & time?

  • Thread starter Thread starter Jon M
  • Start date Start date
J

Jon M

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?????
 
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.
 
=DATEVALUE(LEFT(A7,8))+TIMEVALUE(RIGHT(A7,8))

Regards,
Stefi

„Jon M†ezt írta:
 
Back
Top