text to date conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to convert the following text 20061230.1437 to

12/30/06 14:37
 
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID(A1,10,2),RIGHT(A1,2),0)
and format as Custom m/d/yyyy hh:mm
 
I was using the & " " & instead of the +

Can you tell me why mine wouldn't work?
 
By using the + we are making a value. The integer part of the value is the
date and the decimal part of the value is the time.
 
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

Windows 7 I need to convert date to text 3
Which is the best MBOX Converter Tool different formats conversion? 4
time_report_date-wise_employee-wise 6
How to Convert EML to PST in 2025? 2
Time query 9
Count 1
Peak call times/hours 2
Text to date 2

Back
Top