How do I match up two sets of data in excel ?

Microsoft Excel 2003 (full product)
May 18, 2011 at 01:30:14
Specs: Microsoft
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.

Many thanks,

See More: How do I match up two sets of data in excel ?

Report •

May 18, 2011 at 04:13:18
Please click on my signature line and read the instructions on how to post data in this forum.

Edit your post to make it easier for us to read and we'll see what we can do to help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question