Hello,
I need help with converting a string of text 102558 into a time format that would read, 10:25 and 58 seconds. Also a date format of 141024 to read 10/24/14 or October, 24, 2014. Can anyone suggest a possible solution?
Thanks
Oscar
Hello,
I need help with converting a string of text 102558 into a time format that would read, 10:25 and 58 seconds. Also a date format of 141024 to read 10/24/14 or October, 24, 2014. Can anyone suggest a possible solution?
Thanks
Oscar
Dear Oscar,
I have made a file for you. I hope this will help.
Regards,
Giorgi
For Date:
=(MID(A2,3,2)&"/"&RIGHT(A2,2)&"/"&LEFT(A2,2))+0
Format as Date
For Time:
=SUBSTITUTE(TEXT(C2,"00\/00\/00"),"/",":")+0
Format as Custom: "hh:mm:ss"
Row\Col A B C D 1 Date Time 2 141024 10/24/2014 102558 10:25:58
Last edited by AlKey; 10-27-2014 at 05:44 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks