Jul 12 2022 03:03 AM
Good day, I have date and time columns extracted from a source and cannot set the correct excel formats from the source. So, the extract comes through as text e.g. "6/22/2022 12:01 PM" in one cell. I need to perform a calculation on this. So I would have another column indicating the date and time of the next event in the same format as above. I need to determine the time difference between the two.
Is it possible to convert text (6/22/2022 12:01 PM) to date and time excel formats?
Thank you
Jul 12 2022 03:13 AM
Try the following:
Does that work? If so, repeat for other columns.
Jul 12 2022 05:26 AM
@Hans Vogelaar thank you, that splits the columns well. the first column (the date) appears in the correct format. The second column (the time) needs further conversion, thank you!
Jul 12 2022 06:12 AM
If you select Delimited and turn off all delimiters, the date and time should end up in a single cell.