How do I convert GMT data to dates?

M

MyVeryOwnSelf

How do I convert GMT data from a CSV file to dates?
Example of my data is: 20070302120000[0:GMT]
Click to expand...


After opening the file in Excel, one way is:
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
 
R

Rodrigo Ferreira

Something like this:

=DATE(LEFT(C2;4);MID(C2;5;2);MID(C2;7;2)) +
TIME(MID(C2;9;2);MID(C2;11;2);MID(C2;13;2))

--

Rodrigo Ferreira


Ron said:
Example of my data is: 20070302120000[0:GMT]


Ron said:
How do I convert GMT data from a CSV file to dates?
Click to expand...
Click to expand...
 

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

How do I convert dates in Excel? 4
Amazon are rubbish 14
htm date & time format 11
time conversion GMT to Pacific 3
Convert dates stored as text 2
Formula to convert time zones?? 2
display time in IST as well as GMT? 5
Convert Amercan dates to English dates 2

Top