View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon M Jon M is offline
external usenet poster
 
Posts: 24
Default 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!