How to change a column with date and time as string format in Excel into a column with the same date and time in date/ti
By : Jonny Frez
Date : March 29 2020, 07:55 AM
wish helps you I have a column in string format in Excel (2010) which shows "yyyy-mm-dd hh:mm:ss" and for an analysis I need it to be exactly the same, except that it is in date+time format instead of string format. , To get both the date and the time, use =DATEVALUE(A1)+TIMEVALUE(A1).