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
没有评论:
发表评论