nikhilboorla Posted September 9, 2016 Report Share Posted September 9, 2016 I have 1000 records in format like 20150911184028 and want to convert into 2015-09-11 18:40:28 Any suggestion for how to convert string to timestamp for all fields in excel Quote Link to comment Share on other sites More sharing options...
timmy Posted September 9, 2016 Report Share Posted September 9, 2016 is it OK to split the number into two different cells, like date in one cell & time in another cell?? if so first split them into two different cells & then follow the steps in the link below https://www.extendoffice.com/documents/excel/3467-excel-convert-serial-number-to-date.html for the external link never tried both time & date in a cell. if you figured it out plz let me know. Thanks Quote Link to comment Share on other sites More sharing options...
BUDDY Posted September 9, 2016 Report Share Posted September 9, 2016 1 minute ago, timmy said: is it OK to split the number into two different cells, like date in one cell & time in another cell?? if so first split them into two different cells & then follow the steps in the link below https://www.extendoffice.com/documents/excel/3467-excel-convert-serial-number-to-date.html for the external link and then u can concatenate both the fields again Quote Link to comment Share on other sites More sharing options...
timmy Posted September 9, 2016 Report Share Posted September 9, 2016 Just now, BUDDY said: and then u can concatenate both the fields again yupp @ TS here's another link how to concatenate https://www.extendoffice.com/documents/excel/1538-excel-combine-date-and-time.html Quote Link to comment Share on other sites More sharing options...
nikhilboorla Posted September 9, 2016 Author Report Share Posted September 9, 2016 thanks,i will try Quote Link to comment Share on other sites More sharing options...
nikhilboorla Posted September 9, 2016 Author Report Share Posted September 9, 2016 i am finding how to split number 20150911184028 to date 20150911 and time 184028 Quote Link to comment Share on other sites More sharing options...
timmy Posted September 9, 2016 Report Share Posted September 9, 2016 Just now, nikhilboorla said: i am finding how to split number 20150911184028 to date 20150911 and time 184028 https://www.extendoffice.com/documents/excel/1669-excel-separate-area-code-from-phone-number.html Quote Link to comment Share on other sites More sharing options...
nikhilboorla Posted September 9, 2016 Author Report Share Posted September 9, 2016 i am able to make 20150911 as 2015-09-11 but unable to make 184028 in time format(i have tried Format cells option in excel) Quote Link to comment Share on other sites More sharing options...
timmy Posted September 9, 2016 Report Share Posted September 9, 2016 12 minutes ago, nikhilboorla said: i am able to make 20150911 as 2015-09-11 but unable to make 184028 in time format(i have tried Format cells option in excel) Hmm!! aa time column ni copy chesi new column lo paste special lo paste as values & numbers ani cheyyi dhen try again for new column. (edited) Quote Link to comment Share on other sites More sharing options...
rrc_2015 Posted September 9, 2016 Report Share Posted September 9, 2016 I would use notepad++ to insert a space in all the records in one go. Copy 1000 Records into n++ . Move cursor to the position where you wanna to insert space (or any character) . Now use alt + shift + down arrow to the end . Now type what ever you want. It will insert into 1000 rows in one go. Quote Link to comment Share on other sites More sharing options...
chicchara Posted September 9, 2016 Report Share Posted September 9, 2016 lets imagine your date is in Cell A2 use the below formula for it =CONCATENATE(MID(A2,1,4),"-",MID(A2,5,2),"-",MID(A2,7,2)," ",MID(A2,9,2),":",MID(A2,11,2),":",MID(A2,13,2)) Quote Link to comment Share on other sites More sharing options...
spider_reddy Posted September 9, 2016 Report Share Posted September 9, 2016 1 hour ago, rrc_2015 said: I would use notepad++ to insert a space in all the records in one go. Copy 1000 Records into n++ . Move cursor to the position where you wanna to insert space (or any character) . Now use alt + shift + down arrow to the end . Now type what ever you want. It will insert into 1000 rows in one go. same pinch nenu ide vadatha....avaro oka mahanu bavudu naku idi nerpichadu first job lo ....adi leka pothe pani vasi poyedi Quote Link to comment Share on other sites More sharing options...
Picha lite Posted September 9, 2016 Report Share Posted September 9, 2016 Contact ABO Quote Link to comment Share on other sites More sharing options...
rrc_2015 Posted September 9, 2016 Report Share Posted September 9, 2016 29 minutes ago, Picha lite said: Contact ABO ABO only do calculations. Concat kastam. If cherry movie , collections*2 If cunny, collections*3 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.