However, if the format of the result cell is set to General, you would get the results in fractions/decimals. It is because the time values are represented as fractions of a number in Excel. In the Excel date system, time is stored like this: In Excel’s internal system: 00:00:00 ...
Note:Ensure that all text dates are in the same format before using this method. If formats vary (e.g., some in DMY and others in MDY), the conversion may produce incorrect results. Converting Complex Text Strings to Dates For more complicated text strings, such as "Wednesday, February 01...