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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating date and time 5
2 dimensional date sort 1
Workday Formula to include date 0
time converting 3
Access General Date Forced To Have Date And Time 2
Help need formula for working out date overlaps 12
Converting text format of time/date into Excel time/date for subtr 5
How to get largest date from a Vlookup 1

Back
Top