Hello,
I have two columns of data. Column A contains a correct timeline for an entire year, and column B contains a timeline over the same period but which contains gaps and errors. (Columns C to F contain sampling data). Columns A and B are in 30 minute intervals. For example:
Column A
01/01/2009 0:00
01/01/2009 0:30
01/01/2009 1:00
Column B is in the same format but there cases where one or two times are skipped so the columns are not the same length.
I need to find the times where data gaps exist and insert blank cells so that Columns A and B line up.
I've just been doing this manually but it's a real pain. Is there a function I can use to find and highlight the differences so I can find them more easily?
The other problem is, although Columns A and B both contain data every 30 minutes, in column B the data is not always at :00 and :30. It changes to :15 and :45 or :28 and :58, etc.
As long as there are two intervals for each hour, then it doesn't matter what the interval is. So, is there a way to find the cells in column B that contain less than 2 intervals in a given hour? And then highlight them or make them stand out somehow?
This is a bit of a ridiculous question, but any help would be much appreciated!!
Thanks,
Caitlin
I have two columns of data. Column A contains a correct timeline for an entire year, and column B contains a timeline over the same period but which contains gaps and errors. (Columns C to F contain sampling data). Columns A and B are in 30 minute intervals. For example:
Column A
01/01/2009 0:00
01/01/2009 0:30
01/01/2009 1:00
Column B is in the same format but there cases where one or two times are skipped so the columns are not the same length.
I need to find the times where data gaps exist and insert blank cells so that Columns A and B line up.
I've just been doing this manually but it's a real pain. Is there a function I can use to find and highlight the differences so I can find them more easily?
The other problem is, although Columns A and B both contain data every 30 minutes, in column B the data is not always at :00 and :30. It changes to :15 and :45 or :28 and :58, etc.
As long as there are two intervals for each hour, then it doesn't matter what the interval is. So, is there a way to find the cells in column B that contain less than 2 intervals in a given hour? And then highlight them or make them stand out somehow?
This is a bit of a ridiculous question, but any help would be much appreciated!!
Thanks,
Caitlin
