nikhilboorla Posted November 10, 2016 Report Share Posted November 10, 2016 I have a numbers like 20160715082219000000000 and i want to convert into timestamp like 2016-07-15 08:22:19 and delete that remaining 0's.Please suggest how to do this conversion? Quote Link to comment Share on other sites More sharing options...
compose Posted November 10, 2016 Report Share Posted November 10, 2016 if your data is in cell A3, you can type in this formula in B3 and copy it down to other cells =MID(A3,1,4)&"-"&MID(A3,5,2)&"-"&MID(A3,7,2)&" "&MID(A3,9,2)&":"&MID(A3,11,2)&":"&MID(A3,13,2) Quote Link to comment Share on other sites More sharing options...
khabardar Posted November 10, 2016 Report Share Posted November 10, 2016 itt Quote Link to comment Share on other sites More sharing options...
krishnote3 Posted November 10, 2016 Report Share Posted November 10, 2016 Good .. 58 minutes ago, compose said: if your data is in cell A3, you can type in this formula in B3 and copy it down to other cells =MID(A3,1,4)&"-"&MID(A3,5,2)&"-"&MID(A3,7,2)&" "&MID(A3,9,2)&":"&MID(A3,11,2)&":"&MID(A3,13,2) Good job 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.