Hello, I use Excel 2010. I have a column of dates and times in the following format 201008061730 (yyyymmddhhmm). How do I convert the data in this column into two columns in the following formats?
06/08/2010 (ddmmyyyy) and 17:30 (hh:mm)
Thanks
Hello, I use Excel 2010. I have a column of dates and times in the following format 201008061730 (yyyymmddhhmm). How do I convert the data in this column into two columns in the following formats?
06/08/2010 (ddmmyyyy) and 17:30 (hh:mm)
Thanks
Hi,
Using formula:
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
=TIME(MID(A1,9,2),RIGHT(A1,2),0)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks