2021年4月1日星期四

convert from text to date format in excel

I have 2 text as below want to convert to date in excel

2/10/2001 4:00:00 AM      2/10/2001 12:30:00 PM  

I tried =DATEVALUE() and TEXT(A1, "mm/dd/yyyy hh:mm") in excel which returns me error

I have another text also want to convert to date in excel as well

2001-11-17T12:29:19  2001-11-17T12:46:34  

which return me same error when I tried to use datevalue formala

https://stackoverflow.com/questions/66913908/convert-from-text-to-date-format-in-excel April 02, 2021 at 10:57AM

没有评论:

发表评论