Hi all
I am having an issue with a formula.
I have inherited some raw data where the date (MM/DD/YYYY), time, and AM/PM values have all been split into three separate columns.
This would be an easy fix if I was concatenating general cells. However because I am combining date and time Excel cannot determine whether or not the time is an AM or PM. I would also like to switch the format of the date column into DD/MM/YYYY, currently it is MM/DD/YYYY.
I have attached an example with values and an expected outcome.
Thank you !
Bookmarks