I have two sets of time data in the format dd/mm/yyyy hh/mm/ss. I need to match them up to one another as one set of data is taken once every 10 minutes and the other taken every half an hour. Is there a way that I can match up the data and have:
column 1/////////////////////// column 2
01/01/2011 01:00:00////// 01/01/2011 01:00:00
///////////////////////////// 01/01/2011 01:10:00
///////////////////////////// 01/01/2011 01:20:00
01/01/2011 01:30:00////// 01/01/2011 01:30:10
Sorry about the slashes(/) had to do it otherwise it didn't format it right.