I've received a sample of data in a rather horrific format for some analysis we need to perform. Times are split into multiple columns, one which represents hours, the other which represents minutes. There are thousands of rows though. I need a way to merge the two into a single cell and format it as time. For example in cell I12 the current value is 07, and in the next cell across (J2), the current value is 45. So what that really represents is 07:45 AM, but for whatever reason its been captured in multiple cells which makes no sense whatsoever but that is how it is. I am unsure how to manually merge them altogether and format them as time, I am aware of concatenate to text strings but there may be a more efficient way of doing this. Any pointers most welcome.