Combining AM and time
Recently received data from another department in Excel spreadsheet.
Unfortunately, time data is split into two cells, i.e., G1= 12:58 and H1= AM.
What is the easiest way to combine them into time format for logical
operations?
Thanks in advance for any help!
|